Step 7 Add PJFs to Department File

Step 7. Add PJFs to Department File

REP009 - Access Routes and PJFs

In this step you will add a calculation type virtual field to the Department file based on the salary data in the Employee file.

1.  Open the Department file iiiDepartments in the Editor. 

2.  Ensure that the Fields in File tab and the Details tab are visible. Notice that no PJFs have been defined.

3.  Select the Access Routes tab to add your new predetermined join fields.

4.  Select the iiiTOEMP access route. Click the Add button on the Home ribbon and select Add PJF from the drop down list.

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

 Use the ellipsis and Find dialog to select the fields.    

     Your Details tab will now look like this:

6.  Compile the file.

7.  Close the file in the editor.