Search code examples
filemaker

Perform find over list of values

In Filemaker11.

I have a table, with a field categoryID, and want to Perform Find on these records.

I want to display only the records which have categoryID as either 1, 2, 4, 6, 12 or 13. Perform Find doesn't seem to allow me to set up ORs... or at least I can't see where it does.

How can I do this?

Note: This table is actually connecting (with read-only permissions) to a table from a MySQL database, so I cannot set up a field which displays the boolean isOneOrTwoOr...

Solution

  • While in find mode, go to the 'Record' menu and select new find request. All find requests are ORed together. You can do the same thing in a script by doing the 'new record/request' script step.