You can locate specific records in a database table from within various data entry and report forms. You may choose actions by pressing the Locate button on the toolbar, entering a description to search for in the Search by Description control, or selecting from the Edit or Search menu items.

Locate - Select to locate and display a record based on a value in one of its fields. The Locate Field Value dialog displays to allow you to enter your locate criteria.

1. Within the "Fields" drop down, specify which field on each record that the system will test while searching. Note: ignore fields that are not pertinent to your search - this component displays all fields defined for that record, some of which may make no sense in the context of a search..

2. Enter the characters for the record you are trying to find into the "Field Value" field. These characters can be either letters or numbers depending on the field you have chosen to search.

3. Select the "Case Sensitive" check box, within the Search Type panel, to limit your search to any record that has an instance of characters anywhere within it that exhibit the same case. For example, if "dOg" is entered into the "Field Value" field and the "Case Sensitive" check box is selected, the system will only locate records that contain an instance of characters that exhibit exactly the same case (i.e. only "dOg", not "DOg" or "dog", etc.).

4. Selecting the "Exact Match" radio button will limit your search to any record that has only exactly what is entered into the "Field Value" field.

5. Selecting the "Partial Match at Beginning" radio button will limit your search for only matches that begin with the data entered into the "Field Value" field.

6. Selecting the "Partial Match Anywhere" radio button will allow the system to locate any matches for the instance of characters entered into the "Field Value" field.

7. Pressing the "First" button will bring up the first match meeting your search criteria.

8. Pressing the "Next" button will bring up the next match that meets your search criteria. You may continue to use the "Next" button to locate more matches.

9. Pressing the "Cancel" button will close the "Locate Field Value" form.

Note: the Next button is the default button. If you press the Enter key the Next button is "pressed".

Search by Description - Select to search by description for a record in the table. Start typing in a description to do an incremental search, or select a record from the drop down.

Find (Lookup) by Description - Select to find a record by description of a specific field for a record in the table. Start typing in a description to do an incremental search, or select a record from the drop down.

Find (Lookup) by Number - Select to find a record by record number of a specific field for a record in the table. This uses the same control as the locate shown above, but specifies a different field.

Questions or problems regarding this web site should be directed to webmaster@summitsoftware.com .
Copyright © 2002-2003 Summit Software Systems, Inc. All rights reserved.
Last modified: Thursday July 22, 2004.