User manual

52 | Using databases
3. Choose Requests menu > Constrain Found Set.
The found set now consists of employees in Sales named Alvarez.
Note To quickly constrain 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 (Windows)
or Control-click (Mac
OS), and choose Constrain Found Set.
Logical OR search
To widen your search, enter criteria in the first request. Click New Request.
Enter the second (set of) criteria. Continue adding requests for each (set of)
criteria, then click Perform Find.
You can navigate among multiple requests using Go to Request on the Requests
menu or clicking the book in Find mode.
Examples:
1 To include customers in New York and customers in Paris in the found set,
type
New York in the City field in the first request, then type Paris in
the City field in the second request.
1 To include companies with more than 100 employees and companies with
more than $100 million in assets, type
>100 in Number of Employees in
the first request, then type
>100,000,000 in Capitalization in the second
request.
1 To include 6th grade students who are in Algebra and 7th grade students
who are in Geometry, type
6 in Level and Algebra in Course in the first
request, then type
7 in Level and Geometry in Course in the second
request.
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.
φμπ10_υσερσ_γυιδε.βοοκ Παγε 52 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ