Reordering field definitionsFileMaker Pro uses the order in which fields appear in the Fields tab of the Manage Database dialog box for all dialog boxes that list fields. You can list fields in the order they were created, by field name, by field type, or in a custom order that you define.
1.
2. In the Manage Database dialog box, click the Fields tab.
4. To define a custom order, drag the double arrow next to the field definition to move the field up or down in the list.
5. Click OK.Click the Field Name or Type column heading in the Fields tab of the Manage Database dialog box. To reverse the sort, for example, from ascending to descending order, click the heading again.