File Enquiry

The File Enquiry routine enables you to retrieve records where insufficient information is known to locate a record. There are two levels of search; basic and advanced.

To carry out a basic search:

Using the basic search, you can enter any consecutive characters contained in the record(s) you want to locate.

From the Search tab of the File Enquiry form, enter any consecutive characters contained in the record(s) within the fields displayed, and click the button.

Tip: Alternatively, leave the fields blank to display all records.

At the bottom of the form, the message Searching... is displayed. On completion, the search results are displayed, together with the message Finished.
To display a record, select the record and click the Open button or double-left click the record.

To carry out an advanced search:

Using the advanced search, you can specify up to six field names as selection criteria for the search.

From the Advanced search tab of the File Enquiry form, enter a Field name.

Tip: A list of valid field names is available from the drop down menu.
Enter a Condition.
Tip: A list of valid conditions is available from the drop down menu.
In the From field, enter a start value.

Tip: The To field is only enabled when you select Ranges as a condition.
Click the icon.
The system adds the criterion to a table.
If you add more than one selection criterion, use one of the following link options to determine the relationship between the criteria:

Note: No link is necessary in a single criterion, or the last one in the case of multiple criteria.
- Click the AND button to denote an AND relationship
- Click the OR button to denote an OR relationship
Repeat steps 1-5 for any additional criteria that you want to add.

Note: If you want to change the sequence in which the system accesses and displays records, click the Fields button and complete the Field Chooser form before you commence the search.
To commence the search, click the button.

At the bottom of the form, the message Searching... is displayed. On completion, the search results are displayed, together with the message Finished.
To display a record, select the record and click the Open button or double-left click the record.

File Enquiry Form

From the File Enquiry form, you can construct a basic or advanced search query to locate records on the system.

Open: Displays the selected record.

Cancel: Cancels the operation discarding any criteria you have added.

Help: Displays help on the current application using the default browser.

Fields: In the event that a file has more than one keypath or index, you can determine the sequence in which the system accesses and displays records.

Case sensitive: Do you want the system to match the case of the search text?

Filter: This field is selected by default. It tells the system to display any records that contain the search text or that match the selection criteria.

: Invokes the search in line with the search text or selection criteria.

Search Tab

From the Search tab, you can carry out a basic record search by entering any consecutive characters contained in the record(s) that you want to locate.

The fields that appear on this tab, and the number of characters that you can enter in each field, vary according to the application that you are currently using.

Advanced Search Tab

From the Advanced search tab, you can key in up to six field names as selection criteria for the records to be searched.

Field: Enter the field name if known.
Tip: A list of valid field names is available from the drop-down menu.
Condition: The relationship between the Field value and the contents of the records to be searched. The available operators are as follows:

=: Equal to (an exact match)

CO: Contains (all records containing the value specified)

<>: Not Equal (all records except the value specified)

<=: Less Than or Equals (all records with a value equal to or less than)

>=: Greater Than or Equals (all records with a value equal to or greater than)

<: Less Than (all records with a lower value)

GT: Greater Than (all records with a higher value)

Ranges: Allows you to specify the values from which you want to start and end the search.

From/To: The criteria against which the system should match records in line with the operator relationship specified previously.
Note: The To field is only enabled if you select Ranges as a condition.

: Adds the criterion to a table.
AND: Denotes that selection criteria are used collectively in an AND relationship.

OR: Denotes that selection criteria are used as alternatives in an OR relationship.

Show records that match these criteria

Within this section of the form, the system displays any criteria that you have added in a table format.

: Allows you to amend the selected criterion.

Tip: To amend the link option, position the cursor over the Logic field, right-click the mouse, and select the required option (AND or OR) from the pop-up menu.

: Deletes the selected criterion.

: Refreshes the form, discarding any criteria that you have added.

Field Chooser Form

The Field Chooser Form is displayed when you click the Fields button on the File Enquiry form. From this form, you can determine the sequence in which the system accesses and displays records under the search results.

Available fields:

This is a list from which you can select the fields you want to display under the search results. To include a field in the search results, select the field and and click the Add button or double-click the field.

Show these fields:

This is a list of fields in the sequence that the system will access and display records under the search results.

To add a field to this list, select the field from the list of available fields, and click the Add button or double-click the field.
To remove a field from this list, select the field, and click the Remove button or double-click the field.
To move a field up the list, select the field and click the button.
To move a field down the list, select the field and click the button.