User manual

Finding and sorting information 3-7
Finding some records while omitting others
For example, to find vendors in the state of New York, except those
in New York City:
1. In Find mode, type the criteria for the records to find (type New
York in the State field.)
2. Choose Requests menu > Add New Request.
3. Type criteria for the records to exclude (type New York in the
City field.)
4. Select Omit.
5. Click Find.
Keep these points in mind:
1 You can have Omit criteria in more than one request.
1 FileMaker Pro works through the requests in the order you create
them. For example, in a Clients database with clients in the US and
France:
1 If the first request finds all clients in Paris and the second request
omits all clients in the USA, the found set contains all clients in
Paris, France but none in Paris, Texas or anywhere else in the
USA.
1 If the order of the requests is reversed (the first request omits all
clients in the USA and the second request finds all clients in Paris),
the found set includes all clients in Paris, France and in Paris,
Texas, but no records for clients elsewhere in the USA.
1 To omit a related record from a portal row (or set of related
records), you must change the relationship or the value in at least one
of the match fields so that the match field of the related record no
longer matches the match field of the master record. For more
information about related fields, see chapter 8, “Working with
related files.”
1 To omit records from a found set after performing a find, see the
next section.
Hiding records from a found set and viewing hidden records
All records that are not in the found set are omitted, or hidden. You
can omit additional records from the found set without doing a new
find.
Note Omitted records are temporarily excluded from the found set.
They still exist in the database.
Viewing, repeating, or changing the last find
To view the most recent find criteria, choose Records menu >Modify
Last Find. Then, to return to the found set, choose View menu >
Browse Mode. To repeat the find, click Find. Or you can modify the
find criteria, then click Find.
To Do this
Omit a specific record Display or select the record to omit, then choose
Records menu > Omit Record.
Omit a series of records Display or select the first record in a number of
consecutive records to omit, then choose Records
menu > Omit Multiple. In the Omit Multiple dialog
box, type the number of records to omit, then click
Omit.
View the omitted set Choose Records menu > Show Omitted.
Bring back all the records
in the file
Choose Records menu (Browse mode) or Requests
menu (Find mode) > Show All Records.