Create an Index for a Table

To create an index for a table created with the Tables window, follow the steps below:

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
   This opens a pop-up
5. In the pop-up box, enter the name of the new index and then click OK
   This closes the pop-up 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 the previous steps 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 use