User manual

Chapter 2 | Using databases 39
Extending (broadening) a found set
You can broaden a found set to expand your search to include additional applicable records
without starting over.
For example, after searching for customers in New York, you can broaden the search to also find
customers in Hong Kong:
1. Perform a find to find customers in New York.
FileMaker Pro displays the found set in Browse mode.
2. Click Find and type the criteria to broaden the search (type Hong Kong in the City field).
3. Choose Requests menu > Extend Found Set.
The found set now consists of customers in New York and Hong Kong.
Note To quickly extend the found set in Browse mode, use the shortcut menu. Click in the field
(or select a partial value in the field), then right-click, and choose Extend Found Set.
Records that match one set of criteria but not another
To narrow your search by excluding records that meet specified criteria (for example, to find
vendors in New York state that are not in New York City), see
“Finding some records while omitting
others” on page 39.
Finding records except those matching criteria
You can exclude (omit) records while performing a find. In other words, you can find information
in your database that “does not equal” your specified criteria. For example, you can find all
invoices except those created in the past 30 days.
Finding records that don’t match criteria
1. In Find mode, type criteria for the records to omit.
2. Click Omit in the layout bar.
3. Click Perform 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. Click New Request.
3. Type criteria for the records to exclude (type New York in the City field).
Click Omit to exclude records
that match the request