Sorting records troubleshooting
• 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:
• you make changes to related fields specified in the sort order. However, only the current parent record is affected.
• 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.
•