When you click the Order toolbar control, VPME displays the Order dialog.
The Order dialog displays your descriptions for the index tags for the form’s active table, view or CursorAdapter. The current order tag is highlighted. You change the order of the records on the form by selecting a different index. The order can be made ascending or descending through the option buttons on the Order dialog.
Tip: You can remove the “Do not use an index” line in the Order dialog by setting a form’s lAllowNoOrder property to .F.
Index Tags Dialog and Toolbar Order Control
VPM Enterprise maintains a table of index definitions for the tables, views and CursorAdapters in the Data Builder. You can view a table’s, view’s or CursorAdapter’s index information by selecting the table, view or CursorAdapter in the Data Builder and clicking the expand list icon (+). The Tags list at the bottom of the expanded list contains the index definition names. Select an index definition name and click the Edit page to see the index definition.
The Tags Edit page allows you to set up the Toolbar Order control. You should do the following on the Tags Edit pages for every table, view or CursorAdapter that is the InitialSelectedAlias on a form:
1. Tag Description: Enter a description for each index tag that you want to display in the Toolbar Order control for the table, view or CursorAdapter.
2. Include in Order dialog: Check the Include in Order dialog check box for each index tag that you want to display in the Toolbar Order control when the form that displays the table, view or CursorAdapter is activated and is not related to any parent form already on the desktop.
3. Include in Order dialog when active form is a Related Forms child form: When a form is displayed whose InitialSelectedAlias is a table that is found to be related to a parent form already on the desktop, every tag listed in the Toolbar Order control dialog must begin with the foreign key field(s) in the child table that links the child records to the primary key field(s) in the child’s parent table, view or CursorAdapter. If a child table index tag is set up this way, check this check box to have the index tag displayed in the Order dialog when the form that displays the table is activated and is related to a parent form already on the desktop.