Sort Records in a Database Table

To make it easier for users to find records in the database table, you can sort the records by any field in the table, either in ascending (A to Z, 1 to 9) or descending (Z to A, 9 to 1) order. You can also sort a list at two levels. For example, you could sort a client list first by state and then within the state by city.

You can also specify an option that allows users to sort the records during the interview. They can sort on any field in the table and have the contents arranged in ascending or descending order (as described above).

To sort the records for the user

1. Open the database component for editing. (See Edit a Database Component.) The Database Editor appears.
2. Click the Sort & Filter tab. The window changes to show sorting and filtering options.
3. Click the first Sort by drop-down button and select the field on which you want to sort.
4. Click the second Sort by drop-down button and select Ascending or Descending.
5. Optionally, to sort on a second level, select a field at the Then by drop-down list and then choose Ascending or Descending.

You can let users sort their own records. To allow this, select Allow sorting by end user at the Options tab of the Database Editor.