Query Builder - Sort Records

The Sort Records page allows you to specify the sort order for your query. You must specify a sort order if you plan to use a search form. This page contains the following elements:

Table

Displays the currently selected table to use in the sort. Allows you to select another table from the drop down list.

Fields

Displays the available fields for the selected table. Allows you to select the field or fields by which you want the records sorted:

 

> Copies selected items to.

>> Copies all fields in the table to the Sort Fields list.

 

Sort Fields

Displays the field or fields currently selected as the sort field. Allows you (by double-clicking) to toggle between ascending and descending order:

< Removes selected fields from the Sort Fields list.

<< Removes all fields from the Sort Fields list.

Up

Moves a selected field up in the Sort Fields selection list.

 

Note: To specify an external table that contains the primary record for your query, move the table to the top of the list.

 

Down

Moves a selected field down in the Sort fields selection list.

How to Use Workshop

WebSpeed Glossary

WebSpeed Library