Quick Start

42 Getting Started Guide
Find records based on criteria
in separate fields
You can find records that match multiple criteria, for example
members who are both from the United States and are new members.
This type of search is commonly referred to as an AND search. To
perform an AND search in FileMaker Pro, type each search criterion
directly into the appropriate field in Find mode.
To find all members who live in the United States and are new
members:
1. Choose View menu > Find Mode.
2. Type USA in the Country field.
3. Locate the Membership Type field, and select the New radio
button.
4. Click Find in the status area.
Your find request returns a found set of two records for the two new
members who live in the United States.
5. To find all of the records in your database, choose Records menu >
Show All Records.
Note It is not necessary to choose Show All Records before
performing a Find, as FileMaker Pro always finds records from the
entire database.
Find records that match multiple
criteria in the same field
Sometimes you need to find records that match more than one
criterion in a single field. For example, you may need to find all
members located in either New York or London. This type of search
is commonly referred to as an OR search, because your found set will
consist of records that match any one of the find criteria.
To perform an OR search in FileMaker Pro, you will need to use
multiple find requests.
1 Type the first search criterion into the appropriate field of the first
find request.
1 Create a second find request and enter the second search criterion
in the same field.
When you click the Find button, FileMaker Pro will retrieve all of the
records that match any of the criteria you’ve entered.
To find all members living in New York or London:
1. Choose View menu > Find Mode.
2. Type New York in the City field.
3. Choose Requests menu > Add New Request.
Notice that the status area shows that there are two requests.
4. Type London in the City field of this second request.
5. Click Find in the status area.
Your find request returns a found set of six records for six members
who live in either New York or London.
Select the New radio button
in the Membership Type field
Number of requests