Create an Index for a Table

Follow these steps to create an index for a table created with the Tables window:

1. Open the Tables window.
2. In the Tables tab, select the desired table by clicking the record for the table.
3. Click the Indexes tab.
4. In the Indexes pane, right-click and select Insert. The application displays a dialog box.
5. In the dialog box, enter the name of the new index and then click OK. The application closes the dialog box and adds a new record to the pane.
6. In the Available Columns pane, select the column to be used for indexing by clicking the record showing the column.
7. Click the right-pointing arrow between the two lower panes to move the selected column to the Index Columns pane.
8. Repeat steps 6 and 7 for any additional columns to be used for indexing.
9. When all desired columns are shown in the Index Columns pane, complete the Order column to indicate the relationship of the index columns to each other.
10. Click the Tables tab.
11. Right-click the record selected in step 2 and select Apply Changes. The new index columns are now in force.