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 use Browse mode to find records that have:
1 matching data in any field using quick find
1 matching data in a single field
1 use Find mode to:
1 find records that have matching data in specific multiple fields
1 find records matching a range of data
1 narrow your searches by omitting records
1 save a find request, modify it, and use the new request to locate different records
1 sort records in ascending order (a to z) and add a new record in sorted order
Note 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.
Use quick find to search a database
Quick find gives you an easy way to search across all fields on the current layout.
In the membership database, find all records for members named John who are located in the UK.
1. Open Sample Copy.fp7, located in the Tutorial folder.
2. Notice that the database is in Browse mode and that the active layout is Data Entry.
You can use quick find to search for common text located in different fields in a database.
3. Type John UK in the quick find search text box in the upper-right corner of the status toolbar.
Type the text you want to find here