Home > Designing and creating databases > Creating a database > Changing field definitions > Reordering field definitions

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.	In the Manage Database dialog box, click the Fields tab.

3.	If your database contains more than one table, select the appropriate table from the Table list.

4.	In the Fields tab of the Manage Database dialog box, choose the order you want from the View by list.

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.

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.