U.M. (Windows)

Table Of Contents
Working with information in records 4-31
4. Click Sort.
To cancel before sorting is finished, press Esc.
Keep these points in mind:
1 To sort records that have container fields that you want in order,
create a text or number field that describes or identifies the contents
of the container field. Then sort by the text or number field.
1 To restore records to the order in which they were added to the file,
choose Sort from the Mode menu, and then click Unsort in the Sort
Records dialog box.
1 When you sort repeating fields, or related fields in portals, FileMaker
Pro uses only the first value in the repeating or related fields to sort
records. To sort records based on values other than the first value,
make separate records for each repeating value.
1 You can specify a sort order for related fields. If the match field in
one record in a file relates to the match field in more than one record
in a related file, you can specify that the related field in the first file
display a sorted value (or several sorted values if the related field is
in a portal displaying more than one row). For more information, see
“Sorting records with related fields” on page 10-35.
Select fields to sort
Select the sorting order