Step 3 Create Access Route from Employee File

Step 3. Create Access Route from Employee File

REP009 - Access Routes and PJFs

In this step you will create an access route from the Employee file to the Department file to describe the file relationship.

1.  Open file iiiEmployees in the Editor. 

2.  Select the Access Routes tab. Ensure that the Details tab is visible.

3.  Use the Add button on the Home ribbon, to select Add Access Route from the menu.

4.  In the Details tab, enter the following characteristics:

5.  Click on Keys / New and use the ellipsis button and Find dialog to select the Key Field/Value to lookup a Department as,iiiDeptCode.

6.  Your Access Route definition should look like the following:.

7.  Save and close the file.