Editing and setting indexes and primary keys

Although you will usually set the indexes for your table by using the Format button when you set the data types for the fields, you can also set or edit them in the Table Indexes box of the "Format Table" (or "New Table") dialog. You first need to click on the Index button to access the Table Indexes box.

To set a new index:

  1. Click in an empty row in the Field Name column.

  2. Click on the arrow to display all the available fields and then click on a field.

  3. Give the index a name in the Index Name column (it's best to use the same name as for the field).

  4. Once you have given the index a name, click anywhere else in the row to activate the Primary Key and Unique checkboxes. You can now set the index type by checking the appropriate boxes:

You can edit indexes in the Table Indexes box. Click in the row that contains the index to be edited and then check or uncheck Primary Key and Unique checkboxes, as appropriate. For more details on editing indexes, see Checking indexes and primary keys.