By default, the sort order of the data that appears in the frame is based on the order of the columns in the table. In addition, each column returns data in ascending order. This sort order can be changed by clicking Form, Sort. The Set Data Sort Order dialog appears.

To change the sort order by columns, click a column in the Columns list field and click the right arrow. It then appears in the Order By Columns list field. Subsequent column choices appear in this list in the order they are chosen. Similarly, a column choice can be removed from the Order by Columns list by selecting it and clicking the left arrow button.

To change the sort order further, from within the Order by Columns list, click the column name and then click the up or down arrow. You can set whether the data for a column is sorted in ascending or descending order. By default, data is sorted in ascending order (that is, Asc is selected). To change the sort order for a column to descending order, select the Desc option from the option field.

When you click OK, the selected sort order takes effect, a new query is performed, and the data values are populated into the fields of the frame.