Step 4 Add a Logical View to Employee File

Step 4. Add a Logical View to Employee File

REP006 - Logical Views

In this step you will add a logical view to the Employee file to key it by the Department field.

1.  Open the iiiEmployees file and display the Logical Views tab.

2.  Select the Designer button on the ribbon and expand the Add menu to select Add logical view. Create a logical file:

     Name: iiiEmpByDeptView

     Description: Employee by Department Code.

3.  Select the Keys/New entry and make the iiiDeptCode field the key.

4.  Compile the file and then close it. Use the Verify / Compile menu option to ensure that you Rebuild indexes and views and Rebuild OAMs.

5.  Display the iiiLIST and select the iiiEmployees file.

6.  Right-click and select Properties from the context menu. Notice that the file properties shows brief details of the file such as Date Modified, Task ID and Local Compile State:

     You will be using this logical view in a later exercise.