U.M. (Windows)

4-32 FileMaker Pro User’s Guide
1 When you add a record to sorted records, FileMaker Pro tries to
maintain the sort order. It adds new records to the end of the group
the current record is in. For example, if you sort records by month and
add a record where the month is June, FileMaker Pro adds the record
to the end of the group of June records. The message in the status area
changes to Semi-sorted to indicate the approximate order. When you
finish adding records, resort them.
1 To create a script with a sort order, define the sort order, and then
click Done. Then define the script.
Sorting by summary fields
You can include a summary field in the sort order. For example, sort on
a summary field named Monthly Sales Totals and on a field named Sales
Region to show monthly sales totals for different sales regions. (To sort
a summary field like Monthly Sales Totals, you must include a second
nonsummary field like Sales Region or Salesperson.)
Keep these points in mind:
1 Sorting by summary fields affects the order of printed or previewed
records but doesn’t change the order of records in Browse mode.
1 A summary field selected for sorting is placed at the bottom of the
Sort Order list. Summary fields can’t be sorted in a custom sort order.
1 If data is already sorted appropriately for the summary report, you
don’t have to re-sort when you add or remove summary fields in the
sort order. Add the summary field as described in the previous
section, and then click Done (not Sort).
Choose FileMaker Help Index from the Help menu, and then type:
E sorting records
Choose FileMaker Help Index from the Help menu, and then type:
E summary fields
?
?