I am trying to sort a field by an invoice number. The invoice number is a serial number automatically generated. For some reason when I sort in assending order it goes 1, 11, 12, 13, 14 rather than 1, 2, 3, 4, etc.
In manage | Database | fields, change the field's data type from text to number. The order you report is what you get when you sort numbers entered into a text field as filemaker then tries to sort your numbers into alphabetic order.