Tutorial

Lesson 3
Finding and sorting records
Your database is a collection of records. Sometimes you’ll work with
all of the records in the database (to mail out an annual catalog for
each customer, for example). Often, however, you’ll work with a
subset of your database—people who come from a particular city, for
example, or records that fall within a particular range of dates.
In FileMaker Pro, this process of searching for records that match
particular criteria is called
finding records. Once you’ve found the
records you want to work with, you can change their order by
sorting
them. Records can be sorted in ascending or descending order.
In this lesson, you will:
1 find records matching criteria in a single field and multiple fields
1 find records matching a range of data
1 narrow your searches by omitting records
1 sort records in ascending and descending order
Important Copy the Tutorial folder to your hard drive or verify that
it is installed before beginning this lesson. See
“Where to find the
lesson files” on page 7 for more information.
Find records based on criteria in
a single field
In the membership database, find all of the members that are from
New York City.
1. Open the Tutorial folder on your hard drive.
2. Open the Sample Files folder.
3. Open Sample03.fp7.
4. Choose View menu > Find Mode.
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.
5. Type New York in the City field.
6. Click the Find button in the status area.
Your find request returns records for four members who live in New
York. This is the
found set.
Notice that FileMaker Pro returns to Browse mode when your search
is complete.
Find
button