Record Maintenance Sub-Form

Overview

The Record Maintenance Sub-Form form option should not be used by anyone except ADP personnel. By opening the selected file it enables a record to be edited directly, without verification. Records can be damaged via this option if edited incorrectly.

To access the record maintenance sub-form:

From the Master Menu, select the Fleet Kompact option and Company required.

The Kestrel Kompact Menu is displayed.
Select the Kerridge Utilities option.

The Kerridge Utilities menu is displayed.
Select the Record Maintenance option.
Double-left-click on the required file within the Record Maintenance Grid.

The form is split into three areas. These are the Titlebar, the Record Maintenance Dialogue Box and the column of Command Buttons at the bottom of the form.

Title Bar

In addition to displaying the form name the Title Bar provides a number of useful buttons.

Record Maintenance Dialogue Box

This form displays a record table of all the fields held within the selected file from the Record Maintenance form.

To view a specific field select the Fields command button. This displays a Field Selection List Boxcontaining a number of fields from which to select.

To view a field highlight and confirm the required field with a double-click of the mouse (This operation can be performed for a number of fields at the same time by double-clicking on each required field to be viewed) and select the OK command button. This action displays the selected fields within the Record Maintenance Dialogue Box.

The list displays up to a maximum of twenty five records at any one time.To view the remaining records the Scroll Bar to the right of the form can be operated in a number of ways:

Holding down the up/down arrow to control movement up and down the List Box

Positioning the mouse pointer over the Scroll Box, hold down the left mouse button, and move the mouse. The mouse pointer moves, dragging the Scroll Box. Move the Scroll Box to the desired location and release the left mouse button.

Position the mouse pointer over the Scroll Bar. Single-click with the mouse, above or below the Scroll Box depending upon the intended direction, as many times as is required to move the Scroll Box up or down to the desired location.

To directly edit the record table a single-right-click of the mouse in any of the columns displays a small menu box with the following options:

Edit Row: Enables the current record to be edited. Alternatively, single-left-click into the row, enter the appropriate data and use the Tab key to move to the next column.

Insert Row: Inserts a blank row above the selected record so that a new record may be added.

Delete Row: Deletes the selected record.

Copy: Enables the details for one record to be copied to other records to speed data entry.

Filter: Displays a Selection Criteria Box which enables selection of only those records meeting the selection criteria. The following mutually exclusive selection criteria option buttons/fields are available:

Equals: Searches the selected column for a value matching that entered in the data entry box at the bottom of the form. Any records equaling the criteria are displayed.

Not equalSearches the selected column for a value matching that entered in the data entry box at the bottom of the form. Any records equaling the criteria are not displayed.

Greater than: Searches the selected column for any records with a value higher than that entered in the data entry box at the bottom of the form. Any records greater than the criteria are displayed.

Less than: Searches the selected column for any records with a value lower than that entered in the data entry box at the bottom of the form. Any records less than the criteria are displayed.

Contains: Searches the selected column for any records with a character string containing the character(s) entered in the data entry box at the bottom of the form. Any records meeting the criteria are displayed.

Range: Searches the selected column for any records with a value which is equal to or between the character(s) entered in the two data entry boxes at the bottom of the form. Any records meeting the criteria are displayed.

No filter: No filter is applied to the record search. The Reset command button also activates the "No Filter" option.

COMMAND BUTTONS:

A number of command buttons are available. Some buttons are context sensitive and are dimmed and only become available dependent upon the particular process that is being accessed. The full list of command buttons is as follows:

Exit: Exits the form and returns to the Miscellaneous Options Menu.

Help: Provides online access to a context sensitive Help form.

Sort: Sorts the records by the chosen keypath. Upon selection, a Keypath List Box is displayed from which the appropriate keypath (if there is more than one) is selected.

Reverse: Check box that, when selected, sorts the records in descending order.

Refresh: Redisplays the records on the form with any new modifications.

Autorefresh: Check box that, when selected, automatically redisplays all records on the form after an amendment.

Start At: Restricts a Sort by allowing entry of a character string from which to start.

Finish At: Restricts a Sort by allowing entry of a character string at which to finish.

Fields: Purpose of this field is to allow the display of a user-defined selection of fields for every record. This is intended to reduce data entry errors.

Ad-hoc: Selection of this button displays a further form that provides an Ad-hoc Report Generator for the creation of quick query reports to form. An enquiry is formulated by completing a simple set of verbs and field names. A saved formulated query can be retrieved for future use.

Column: Displays each field in a record by row, with the field name in the left-hand column and the field data in the right hand column. Within this option, records may be created, amended or deleted.