Sort Fields

The idea of sort fields is to impose a sort order (or index) on the items in the stock list in addition to the standard fields in the table. While Nomen, type and class are important identifiers they cannot normally provide both good descriptions and good sorting keys at the same time. The sort fields allow you to provide such an order.

Certain classes have predefined sets of sort keys, each of which has a 4-character value. The total string is used to order items within the same class. For example it could group casing items by size, then weight then thread and similar.

This window is displayed by clicking on the Sortfields option in the Catalogue menu.

It defines the sortfields that can be used to define a sort key for a particular Class of item.

This table can be sorted by Number or Description by clicking on the [A/Z] button

Advanced option: This table should normally only have items added by the database administrator and is used infrequently.

There is no provision for prevention of duplicate records being added at different sites on the same day.

1. Click "+" to open dialog and add a new record (click "▲" to open an existing record to edit, and "-" to delete a record)

2. Enter the short code of 4 characters

3. Enter a description

4. The number will be assigned by the program.

Document SortFields.htm