Hi All, I am new. I am using File Maker Pro 14 and pasting multiple values into a field in my find gets me nothing. I would think this would be just a simple process but seem to keep hearing about scripting it.
1. I want to paste 2 serial numbers into my "Serial Number" field and get a result set of those 2 serial numbers.
So I hit "Search for Records" then in the Form paste "1234" and "5678"
I would like for both of these records to be returned in the result set
It should do something in the background like "select * from Table1 where SERIAL_NUMBER IS (1234) OR (4567)
Why does this seem to be so difficult in the GUI, is there a delimiter like ;
Plz, help - I can't imagine if I have 100 serial numbers I have to continue to hit add to find??