Sorting Collections

When you retrieve a collection of records, you often sort them according to the contents of one field. The system lets you sort based on:

To sort a collection based on the contents of a grid column, double-click the column heading for the column. To toggle the sort between ascending order and descending order, repeat this action.

To sort a collection based on a field value:

  1. In an open a form, display the collection you want to sort.
  2. Click in the field on which you want to sort.
  3. Select Edit > Sort Collection.
  4. (Optional) By default, records are sorted on the field in the primary collection that currently has focus. If you are not sorting the primary collection, select a collection and field:
  5. (Optional) By default, records are sorted in ascending order, regardless of capitalization. To sort by descending order, select the Descending check box.
  6. (Optional) To take into account capitalization when sorting, select the Case-sensitive check box.
  7. Click OK.

Notes About Sort Order

When sorting collections, a few sort-order concepts must be kept in mind:

(blank field)

#222

222

2220

@201

XL-64

xl-64

This is because, in text-character (ascending) order:


Related Topics

Working with Collections

Finding Records Using a Query Form

Finding Records with Filter-in-Place

Finding a Value in a Collection of Records