2.0

Managing Database Records
8-12 Managing an OmniForm Database
Sorting Records
You can sort records in OmniForm in ascending, descending, or original
order entry. This is useful for many situations. If you wanted to export
mailing information, for example, you could sort records by postal code
to reduce bulk mailing costs, or invoices by date to find the most
delinquent accounts.
To sort records:
1 If you are in Design View, click the Fill button in the standard
toolbar or choose
Fill
in the View menu to switch to Fill View.
2 Choose
Sort...
in the Records menu.
The Sort dialog box appears.
3 Select the field by which to sort in the
Field Name
pop-up menu.
All the fields in your form are listed here.
To make sorting as easy as possible, give each field a unique name
after it is created. Otherwise, you could have fields named
FillText1
,
FillText2,
and so forth, making it difficult to figure out which fields
contain what information. See “Defining Objects” on page 6-16 for
detailed information.
4 Select a sort order.
•Select
Ascending Order
to sort records from least to greatest;
for example, from A–Z or from 0–100. Symbols precede
numbers which precede letters: $40, 40, Forty
.
•Select
Descending Order
to sort records from greatest to least;
for example, from Z–A or from 100–0. Letters precede
numbers which precede symbols: Forty, 40, $40
.
•Select
Original Order Entered
to sort records in the order in
which you originally entered information in the selected field.
This is useful to view the history of information entered.