8 Replies Latest reply on Jun 6, 2017 9:17 AM by philmodjunk

    So simple - can it be done through GUI

    nhooker

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