Step 3 Execute Search by Description Form

Step 3. Execute Search by Description Form

REP006 - Logical Views

In this step you will execute the Search by Department Description application. One of the typical uses of logical views is to make a file searchable by a field such as a name.

1.  Execute form iiiSearchDeptByDesc by clicking the Execute button on the Editor toolbar.

2.  Type in one of your department descriptions such as Administration and click on the Find Department Code button to retrieve the department code.

     The departments descriptions are Administration, Legal, Marketing, Company Training, Business Travel. Remember that the descriptions are case sensitive.

     If necessary, execute the iiiMaintDepartment form to see how you entered the descriptions.

     Note: This is very crude form which simply demonstrates your logical file is working. A logical file of this type (based on a name or description) would usually be used to select a list of departments generically, using a partial key. For example, "show all departments with a description beginning with Ad".

3.  Exit the form.