To select an index for a rowset

Topic group

Depending on the table type, a rowset may be displayed in a form in different default orders. When you first open a dBASE table, it appears in natural order. When you first open a Paradox table, the natural order is the primary key order.

For dBASE tables, the production .MDX file opens automatically with the table, but the indexes it contains are not in effect until you select one.

To order rows that appear in a form in a specific way, select the index you want:

1. Open the form in the Form designer.

• Select the active Query object.

• In the Inspector, select the rowset property.

• Click the rowset property tool button. The Inspector displays the rowset object’s properties.

• Set the indexName property to one of the available indexes.