User manual

54 | Using databases
Finding some records while omitting others
For example, to find vendors in the state of New York, except those in New
Yor k Ci ty:
1. In Find mode, type the criteria for the records to find (type New York in
the State field).
2. Click New Request.
3. Type criteria for the records to exclude (type New York in the City field).
4. Click Omit.
5. Click Perform 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 US, the found set contains all clients in Paris, France
but none in Paris, Texas or anywhere else in the US.
1 If the order of the requests is reversed (the first request omits all clients
in the US 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 US.
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 4, “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 25.
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 55.
φμπ10_υσερσ_γυιδε.βοοκ Παγε 54 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ