Sorting the DatabaseΒΆ

To sort the database click the Sort and Re-index Database icon or choose File | Sort and Re-index Database from the Database Records Management screen.

You will be presented with the following items.

Sort Key

An index expression to be used as the sort key. This can be a field name or an expression involving several fields. Available field names will be displayed in the Dialog Box. If an index file has been created for the database, the index value expression will be displayed as well.

Sort Sequence

Indicate which order the database is to be sorted. The sort order can be Ascending or Descending order.