Working with Your Database - FileMaker Pro 13: The Missing Manual - page 32

with all available fields listed on the left. You tell FileMaker how to sort by moving a field to
the list on the right.
NOTE
FileMaker starts out by listing the fields shown on the Current Layout. If the field you want to sort
by isn't in the list, then, from the pop-up menu above the list, choose the second option. Instead of
Current Layout, that option starts with Current Table. (Learn more about tables in Chapter 5 .)
Figure 1-16. The Sort Records dialog box has a lot of options, but the two lists on top and the first
two radio buttons are critical to every sort you'll ever do in FileMaker. You pick the fields you
want to sort by and the order in which they should be sorted and then click Sort. That's the essence
of any sort, from the simple to the most complex.
Here's how to sort your found set of records by Last Name:
1. In the Status toolbar, click Sort. Or choose Records → Sort Records, or press
Ctrl+S ( ⌘ -S) .
The Sort Records dialog box ( Figure 1-16 ) appears.
2. From the list on the left, select the Last Name field and then click Move. (Or
double-click the field name.)
The field name appears in the Sort Order list on the right.
3. Click Sort .