Help

Finding, sorting, and replacing data
F
ILEMAKER PRO HELP 127
3. Click OK.
To delete all saved finds for a user from an externally authenticated account:
1. Follow the steps in Creating accounts that authenticate via an external server to access the
Edit Account dialog box.
2. In the Edit Account dialog box, click User Data.
3. In the Manage User Data for External Account dialog box, select the user name and data
you want to delete.
4. Click Clear.
Sorting records
FileMaker Pro stores records in the order they were added to the file. Sorting 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.
By default, the records remain sorted until you perform a find or sort records by different criteria.
When you add a new record in a sorted found set, or change the data in a sort field of a sorted
record, the record appears in the correct position in the sort order when you
commit the record. To
change the way new and changed records are sorted, see Options for sorting records.
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.
For details about the sort options in the Sort Records dialog box, see Options for sorting
records.
3. Click Sort.
To quickly sort records by a single field:
1. In Browse mode, click Table View .
2. Right-click the column heading of the field that you want to sort by.
3. From the shortcut menu, choose Sort Ascending or Sort Descending.
See Working with data in Table View.
Click To
New or Edit Create another saved find request, or rename or change this
saved find. See
Saving a find request.
Duplicate Make a copy of the saved find and its search criteria.
Delete Delete one or more selected saved find requests from the list.
View by Reorder the list of saved finds.