Follow these steps to To create an index for a table created with the Tables window, follow the steps below:
- Open the Tables window.
- In the Tables tab, select the desired table by clicking the record for the table.
- Click the Indexes tab.
- In the Indexes pane, right-click and select Insert. The application displays a dialog box.
This opens a pop-up - 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. - In the Available Columns pane, select the column to be used for indexing by clicking the record showing the column.
- Click the right-pointing arrow between the two lower panes to move the selected column to the Index Columns pane.
- Repeat the previous steps 6 and 7 for any additional columns to be used for indexing.
- 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.
- Click the Tables tab.
- Right-click the record selected in step 2 and select Apply Changes.
The new index columns are now in force.use