User manual

58 | Using databases
For more information about finding and replacing data, see Help.
Sorting records
FileMaker Pro stores records in the order they were added to the file. Sorting
temporarily rearranges records, so you can view, update, or print them in a
different sequence.
You choose the fields whose contents you want to sort by. The first sort field
arranges the records based on the field’s contents. The second sort field
arranges records when two or more records have the same value in the first sort
field, and so on. You can sort records in ascending order, descending order, or
in a custom order.
The records remain sorted until you perform a find, add new records, or sort
the records again. When you add a new record to a sorted found set, the new
record appears in the correct position in the sort order when you commit the
record.
To sort the records in the current found set:
1. In Browse mode, click Sort in the status toolbar.
2. In the Sort Records dialog box, choose fields for sorting, in the order you
want them sorted by, and sort options.
To choose a sort field visible on the current layout, no matter what table it
is in, choose Current Layout (LayoutName) from the table list, then double-
click a field in the list.
To choose a sort field that is in the current layout’s table, whether or not it
is on the current layout, choose Current Table (TableName) from the table
list, then double-click a field in the list.
For information about sort options, see Help.
Replace Replace the Find what data with the Replace with data.
Replace All Replace all occurrences of the Find what data with the Replace with data.
At the end of the Replace All operation, you see a summary of the number
of occurrences found and replaced.
Click To
φμπ10_υσερσ_γυιδε.βοοκ Παγε 58 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ