User's Manual
BrailleNote Apex QT User Guide
18-422
You must sort by at least one field and can sort on up to 3 fields in a specified order. The records
are initially sorted by the first field you specify. This means that records will be grouped together
when the first field is identical. These records are then sorted by the second field you specify. In
cases where this field is identical, the third sort field is used. When you first create a database, the
first field in the Field Definition List is automatically chosen as the sort order.
When you enter the Sort Order List, the initial prompt provides a list of the sort order fields in the
order that they are presented. For example, "Sort order is First Name, Last Name, Membership
Number. Change?". To leave the sort order unchanged, press N. The Record Title prompt will then
be displayed. To change the Sort Order, press Y and the Sort Order List will be displayed.
The Sort Order List presents each field in the sort order one by one, therefore allowing you to add,
remove or change the fields. There will always be a 1st sort field, displayed as "1. Sort by
(fieldname)". If there is a 2nd sort field, KeyBase will display, "2. Then sort by (another
fieldname)". The 3rd sort order will be displayed as "3. Then sort by (yet another fieldname)".
However, if there is no 2nd sort field, the prompt for the 3rd field will not be presented. If this is the
case, the 2nd sort field will display"2. None".
To change a sort order field or add another field, move through the list by pressing SPACE or
BACKSPACE until the position you want to change is displayed, and press ENTER. You will be
presented with the Field Selection List. Move through this list to find the field you want and press
ENTER.
A sort order can be removed by pressing CONTROL with I. If you remove any field (except the last
field), the subsequent fields move down to replace the field that has been removed. Remember that
there must always be at least one field in the Sort Order. If only one field remains, it cannot be
deleted so must be changed instead.
Note: If you change the sort order of existing records, the database will be sorted again once you
return to the KeyBase menu. There may be a short delay during the sorting process.
Once you have finished the order sorting process, press ESCAPE. KeyBase will prompt: "Record
title (field 1; field 2; field 3). Change?".