To view the current order of a database's fields, run either a Detailed Table Report or a Quick Field Report.

To change field order:

  1. Choose Schema > Reorder Fields. The tables defined for your database appear in alphabetical order.
  2. Select the table for which you want to reorder the fields. A dialog box similar to the following appears:


  3. Specify whether to order fields either by name or by order number.
  4. Specify the starting number and the number by which to increment.
  5. Choose OK. The Data Dictionary arranges the fields for the selected table in the specified order.
  6. Choose OK to return to the Data Dictionary main window.