Page History

Follow these steps to 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. The application displays a dialog box.
   This opens a pop-up
5. In the dialog pop-up box, enter the name of the new index and then click OK. The application
   This closes the dialog 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 6 and 7 for any additional columns to be used for indexing.
9. When all desired columns are shown in the Index 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.use