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

Outcomes