Filemaker Pro 10 TU691LL/A Benutzerhandbuch

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:

find records matching criteria in a single field and multiple fields

find records matching a range of data

narrow your searches by omitting records

save a find request, modify it, and use the new request to locate different records

sort records in ascending order (a to z) and add a new record in sorted order

Verify that you have Sample Copy.fp7 before beginning this lesson. See lesson 2 for information on 

accessing the Tutorial folder and making a copy of Sample.fp7.

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 Sample Copy.fp7.

You can choose File menu > Open Recent, then select a filename from the list to quickly open the 

sample file during this tutorial.

3. Notice that the database is in Browse mode and that the active layout is Data Entry. 

The first record is for a member from New York City.

4. Right-click (Windows) or Control-click (Mac OS) the City field.