Manage Indexes dialog box

Select an index to edit, or choose the New button to create an index. The Define Index dialog box will open, where you can create, modify, or delete index tags and indexes.

You can also specify the index to use as the master index. The master index determines the order of the rows in the table you are viewing. The Manage Indexes dialog box displays a list of tags already defined for your table.

Dialog box options

Index name

The name of the index. If the name is Primary, that index is the table's primary index. Its name is assigned automatically.

Index key

The field(s) on which the index is created. The key expression specifies the sort order of the rows. Click or use the arrow keys to choose the index that you want to use as the master index.

New

Click the New button to create a new index tag with the Define Index dialog box.

Modify

Click the Modify button to modify the selected index tag with the Define Index dialog box.

Delete

Click the Delete button to delete the selected index tag from the index file (.MDX).

How to get there: In the Table designer, choose Structure|Manage Indexes.