Define Primary Key dialog box

Define a primary index for a table that supports this feature. A primary index, or key, is made up of a field or group of fields. The fields of a primary index must be consecutive fields, starting with the first field in the table structure. The primary index establishes the physical sort order for the table.

Dialog box options

Available fields

Displays the list of table fields that can be used in the index. Select the fields that you want to use and move them to the Fields of Primary Key list by using the arrow buttons.

Fields of index key

Displays the list of table fields on which the index is based. To remove a field from the list, select it and use the arrow buttons.

Arrows

Click the > arrow to add the selected field in the Available Fields list to the bottom of the list of fields in the Fields of Primary Key list.. Click the >> arrow to move all the available fields to the Fields of Primary Key list..

Click the < arrow to remove the selected field from the Fields of Primary Key list to the bottom of the Available Fields list Click the << arrow to remove all the selected fields from the Fields of Primary Key list to the bottom of the Available Fields list.

How to get there: In the Table designer, choose Structure|Define Primary Key.