Step 4. Add a Logical View to Employee File

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 in the editor and select the Logical Views tab.

2.  On the Home ribbon, 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 Compile with options to ensure that you Rebuild indexes and views and Rebuild OAMs. It is not necessary to Rebuild Table.

5.  Display the list 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.