User manual

Chapter 1
|
Using databases 31
Finding records that don’t match criteria
For example, to find all sales records except those for the city of
London:
1. In Find mode, type criteria for the records to omit.
2. Select Omit in the status area.
3. Click Find.
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 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 32.
Select Omit to exclude records that match
the request