Adding a Column to a Key or Index
To add a column to a key (or to an index):
1. Right-click the table concerned and select Properties.
The table properties dialog box opens.
2. Click the drop-down list then Components.
3. In the Index section, right-click on the index and select Properties.
The properties dialog box of the index appears.
4. Click the drop-down list then Columns.
5. Click the Connect button.
The query dialog box appears.
6. Find and select the column to be added to the key (index).
It is possible to indicate the sort order of the key or index, which can be “Ascending” or “Descending“.