Sorting records troubleshooting
Records don't sort in the correct order
 •
If numbers don’t sort correctly (11 is before 2, for example), they are entered in a field formatted to contain text data. Change the field type to Number. For more information, see About choosing a field type.
 •
 •
You might have hidden values in a field that is formatted as radio buttons or checkboxes. Values that are not on the value list do not show. To display them, add an unformatted copy of the field to a layout, then click into the field to see what it actually holds.
 •
FileMaker Pro automatically updates sort order in a file when:
 •
 •
any schema change, a local import-record operation, a local operation that replaces the contents of a field, a local field relookup, a local ODBC operation, or a redefined foreign data source modifies records in a table.
 •
FileMaker Pro does not automatically maintain sort order for modifications to:
 •
 •
related fields. For example, when you sort in Table view on a related field and then create a blank record, the record remains at the bottom of the sorted records instead of sorting to the top with other blank records.
 •
 •
Records disappear after sorting
 •
Records with nothing in the sort field sort to the top of the list in an ascending sort. Scroll down (or click the book icon to page down) to see your records or omit blank records before sorting.
Sorting repeating fields
 •
 •
Related topics 
Sorting records