1 Using the Find Screens

A find screen enables you to find records that match the selection criteria. All find screens in the system contain the following areas:

• Buttons

• Query fields

• Display grid

Accessing a find screen

To access the context sensitive find screen for a screen or tab, click Find.

Searching the database

Follow these steps to search the database.

1. Enter selection criteria in one or more query fields at the top of the screen and click Search.

   If a field is left empty, the search retrieves all instances of that field.

   Result: This triggers an Oracle Like% query that returns the first 100 records that begin with the selection criteria. These are displayed in the display table at the bottom of the screen.

   Example: If you enter 123 in a query field, the system returns records such as 123, 1234, and 12345.

   Note: These are the first 100 records entered in the database, and they display in no particular order. If you do not find the record you are searching for, you need to conduct a more specific search.

2. To display the record in the main screen, select the record line and click Close.