A Table can have a number of Indexes related to it. Each Index has a unique name and consists of one or more Columns - the same Columns that constitute the Table. For each Column that includes an Index, you can specify the sort order in the through the Property pages.
To create an index:
1. Right-click the Table that is to own the Index, point to New, and then click Index
2. Type the name of the new Index, and then press the Enter key.
A new Index is added to the Table.
To define columns for an index:
1. Open the Property Pages for the Index.
2. Click the Column tab.
3. Click the Link button, and then use the Links Editor to select the required Columns.
Link button, and then use the Links Editor to select the required Columns.