U.M. (Windows)

Working with information in records 4-29
Important You can’t retrieve deleted data, and you can’t undo deleting
records.
Before you delete records, it’s a good idea to make a backup
copy of your file.
Sorting records
FileMaker Pro stores records in the order they were added to the file.
However, you often want to work with records in sorted order. Sorting
temporarily rearranges all or a group of records (the found set) based on
the entries in a field or set of fields, so you can browse, update, or print
the records in a different sequence.
You sort records by selecting 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 based on a value list.
FileMaker Pro keeps the records in the sorted order until you perform a
find or sort the records again.
1. To sort some but not all of the records, find the records to sort.
See “Finding information” on page 4-19.
2. Choose Sort from the Mode menu.
To delete Do this
One record Select the record to delete and choose Delete Record from the
Mode menu. In the alert message, click Delete.
A group of records Use Find or Omit Multiple to select a subset of records to delete,
and then choose Delete All from the Mode menu. In the alert
message, click Delete.
All records in a database Choose Find All from the Select menu, and then choose Delete
All from the Mode menu. (Or create a clone of the database
with no records. See “Saving a copy of a file” on page 1-11.)
Choose FileMaker Help Index from the Help menu, and then type:
E records, overview
?