User manual

Using databases 29
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 record is no longer related. For
information about related fields, see
chapter 3, “Working with
related tables and files.”
1 You can open another window in order to perform different find
requests on the same data. See “Opening multiple windows per file”
on page 15.
1 To omit records from a found set after performing a find, see
“Hiding records from a found set and viewing hidden records” on
page 29.
Deleting and reverting requests
To delete a request, go to the request you want to delete, then choose
Requests menu > Delete Request.
To restore a request to the way it was when you last committed it,
choose
Requests menu > Revert Request. Requests are committed, for
example, when you click out of all fields, go to a different layout or
request, or perform a find.
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.
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.
Important Omitted records are temporarily excluded from the found
set. They still exist in the database.
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.