Adding a column to a view index in a query table

Chapter 3 Building Physical Diagrams

Adding a column to a view index in a query table

View indexes are defined on the columns of a query table.

You can indicate the index order for each column attached to a view index, by selecting Ascending or Descending in the Sort column for each column listed on the Columns page of the view index property sheet.

To add a column to a view index in a query table:

In the view index property sheet, click the Columns tab.

The Columns page appears. It lists columns associated with the index. At index creation, the list is empty as there are no columns yet associated with an index.

Click the Add a Row tool.

A list of columns defined for the table appears.

Select one or more columns and click OK.

You return to the Columns page. The columns associated with the index appear in the column list.

Select Ascending or Descending in the Sort column of each column.

Click OK in each of the dialog boxes.