U.M. (Windows)

4-26 FileMaker Pro User’s Guide
In addition, you can find records that don’t match the request. For
example, to work with all the sales records except those for the city of
London, you can specify London in the find request and then omit those
records. It’s often easier to omit the records you don’t want than to
search for all the records you do want.
Note FileMaker Pro works through multiple requests in the order you
specify, so define the omit requests last. Otherwise, subsequent find
requests might include records that should be omitted.
The following example shows three find requests where one request
omits a group of consecutive records. Together, these three find requests
find all records of employees in Marketing and Operations and omit
those whose title is Director.
To Do this
Omit a specific record Display or select the record to omit, and then choose
Omit from the Select menu.
Omit groups of records Display or select the first record in a number of
consecutive records to omit, and then choose Omit
Multiple from the Select menu. In the Omit Multiple
dialog box, type the number of records to omit, and then
click Omit.
Bring back all the records in the file Choose Find All from the Select menu.
Switch the found set with the
omitted set
Choose Find Omitted from the Select menu.
Find some records and omit others In one request, type the criteria for finding the records.
In a second request, click Omit, and then type the criteria
to remove records from those found. Then click Find (or
choose Perform Find from the Select menu).
Find records that don’t match
the request
In one request, type criteria for the records to omit.
Click Omit, and then click Find (or choose Perform Find
from the Select menu).