User manual

Chapter 2 | Using databases 42
4. Click one of the buttons to perform the type of find/replace operation you want.
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.
By default, the records remain sorted until you perform a find or sort records by different criteria.
When you add or change a record in a sorted found set, the record appears in the correct position
in the sort order after you commit the record. To choose an option to change the way new and
changed records are sorted, see Help.
To sort the records in the current found set:
1. In Browse mode, click Sort in the status toolbar.
Note To sort records in Table View in Browse mode, see “Working with records in Table View”
on page 29.
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.
An option in Search across In Browse mode, search across all records in the current layout or just in the
current record.
In Find mode, search across all find requests in the current layout or just in the
current find request.
Note In Layout mode, FileMaker Pro searches just in the current layout.
An option in Search within In Browse and Find modes, search within all fields in the current layout or just in
the current field.
Click To
Find Next Search for and select the next occurrence of the Find what data.
Replace & Find If there is selected data that matches the Find what data: Replace the Find what data
with the Replace with data, search for and select the next occurrence.
If there is no selected data that matches the Find what data: Search for and select the
first occurrence of the Find what data.
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.
Select To