Field Display Order

Use this option to define the order in which non-key fields in a table are displayed for a user when editing and browsing table rows. Normally, the fields in a table will be stored in the order in which they were created. The Field Display Order option allows you to modify that order to display the fields in the manner most appropriate for a given user. Multiple Views may be created for one table, each one with a different display order based on the user’s requirements. Fields that are added to the table at a later date, using the restructuring facility described later in this chapter, may be displayed in any position you wish. The field display order does not affect storage order.