Finding Records

Gallery Express provides a standard interface for locating and loading records. The 'Find' form will be used on all forms where record selection is required and is loaded by pressing the 'Find' button - usually located in the bottom left corner of a form. The button will be labelled according to the type of record to be selected (ie. Find Customer on the Add/Edit Customer form, Find Artist on the Add/Edit Artist form).  

Selecting a record from this form is made simple by providing filtering capabilities for the records. To locate a record using the filter, follow these steps.  

1. Select the column to filter. The fields that are available for filtering appear in the Select Column to Filter drop down box.  
2. Type your selection criteria in the Enter filter expression box.  
3. Press the <enter> key, or click on the Refresh Records button.  

A list of records matching your search criteria will appear on the form. To select a record, either double click on the desired record, or highlight the record and click on the Select Record button.  

Selecting Multiple Records:

Some forms such as the Shows form will allow you to select multiple records at once. To use this feature, hold down the <CRTL> key while selecting the required records. If a form only allows you to select a single record, the first records that was selected will be used.  

Ordering Records:

To order the records that appear on the form, click on the header at the top of the column that you wish to order. The records will then be sorted in ascending order according to the column contents. To sort in descending order, hold down the <CTRL> key while clicking on the column header.  

Refreshing the Records:

If you wish to reload all available records in the form, first clear the Enter filter expression box then either press the <enter> key, or click on the Refresh Records button.