AnsweredAssumed Answered

So simple - can it be done through GUI

Question asked by nhooker on Jun 6, 2017
Latest reply on Jun 6, 2017 by philmodjunk

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??