Tutorial

16 FileMaker Pro Tutorial
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.
Use Find mode to perform more advanced searches. In Find mode,
you create a find request using the fields in the layout you see.
Type the criteria you want to search for directly into the fields on
the request.
2. Type USA in the Country field.
3. Locate the Membership Type field, and select the New radio
button.
4. Click the Find button 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 finds records from the entire
database by default.
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.
Select the New radio button
in the Membership Type field
Find
button