Reordering field definitions
FileMaker 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.
To reorder field definitions:
1.
With the database open, choose File menu > Manage > Database.
2.
3.
4.
To define a custom order, drag the double arrow Double arrow icon next to the field definition to move the field up or down in the list.
5.
To reorder field definitions by clicking column headings:
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.