User manual

To Do this
Include related fields anywhere Choose a relationship from the relationship
in the sort order list, then double-click a related field in the list.
You can place a related field anywhere in the
Sort Order list—before, after, or between fields
in the master file.
If more than one record in the related file
matches a record in the master file, the sort
will use the value in the first matching record
in the related file, according to the sort order
defined in the relationship. See “Defining
relationships for relational
databases and lookups” on page 8-10.)
Sort related records (rows) in a If your access privileges allow, specify a sort
portal order in Define Relationships. See “Defining
relationships for relational
databases and lookups” on page 8-10.
Remove a field from the Sort In the Sort Order list, double-click the field.
Order list
Remove all fields from the Sort Click Clear All.
Order list
Sort by summary fields See the next section.
For example, to sort sales
regions in order from highest to
lowest total sales.
Unsort the records (return them Click Unsort.
to creation order)
Sort records according to a Select Override field’s language for sort, then
different language than the one choose a language.
used for indexing
Close the Sort Records dialog Click Done.
box without sorting
Finding and sorting information 3-9
Keep these points in mind:
• Data sorts differently in different field types:
This field type Sorts records in this order
Text Alphabetically. Numbers sort by character position.
(Example of an ascending sort: 1, 11, 2.) Numbers sort
before letters. Non-alphanumeric values are ignored
(unless you change the sort language to ASCII).
Number Numerically. Non-numeric characters are ignored.
Date Chronologically. To avoid confusion when using dates,
always use four-digit years. For more information about
how FileMaker Pro handles Year 2000 issues, see
www.filemaker.com.
Time Numerically. Times using AM/PM are sorted according to
their 24-hour-clock equivalent (for example, 8:00 PM is
20:00).
• Records in a sorted portal are re-sorted whenever the relationship
is re-established. (For example, when you browse out of and then
back into the record, or change the value in the match field.) See
“Defining relationships for relational databases and lookups” on
page 8-10.
• Repeating fields sort by the value in the first repetition.
• If you add records after sorting, the status area shows Semi-sorted.
Sort again to incorporate new records in the sort order.
• System formats affect the way numbers, dates, and times sort.
System formats is documented in Help. Choose Help menu >
Contents and Index, click the Index tab, and type system formats.