Finding an Existing record - limited to one field search


#1

When I am searching for a linked record, I can only search if I know the first field (locked) for that table. However, when I start typing, I can see other fields listed in the options for each record that comes up.

I’d like to search by those other fields, that will still get me to that linked record, not by just the first field.

Example. Many of the linked records are listed like XMANS, XMAND, MANGS, UMIMG, UMIMA
I can’t remember all of these codes, but I know what I am searching for - so if I typed something like “Ear Mite” it would show me possible linked records to choose from, of which I would select UMIMG.

Hopefully that makes sense - will try to attach an image.