Sorting a table

You can sort your table records alphabetically or numerically according to the values of key fields. In Ability sorting works in conjunction with the indexes and primary keys you have set for fields in your table. An indexed field will sort faster than one without an index. Also, when determining which fields to sort on, you need to take into account the types of indexes you have assigned to the fields. For instance, non-unique indexes allow duplicate values, and so you may wish to sort on a second field, in addition to the first, when it is possible for the first to contain duplicates (see Indexes and primary keys).

You can perform a simple sort on a single field or more complex sorts on several fields at once. In addition, since any sort applied to a table is undone when the table is closed, you can save a sort as a Sort Order and re-apply it whenever you choose.

See:

Sorting on a single field

Sorting using a sort order