Step 6 Test New PJF in Employee File

Step 6. Test New PJF in Employee File

REP009 - Access Routes and PJFs

In this step you will add the predetermined join field Department description to iiiMaintEmployVirtuals (Real and Virtual Fields in Employee File).

1.  Using the iiiLIST tab, locate and open the form iiiMaintEmployVirtuals.

a.  Display the Design tab.

b.  In the iiiLIST tab locate the iiiDeptDescPJF (Department Description) field.

c.  Drag the iiiDEPPJF field onto the form above the virtual fields. You may need to move the existing virtual fields lower.

     Hint: Select the four virtual fields using the Shft+Left mouse button, and drag them lower with the Ctrl+Cursor key.

     Note: You will not need to change the source code, because the FETCH statement uses the Fields(*all) parameter.

2.Compile the form.

3.Execute the form.

a.  Fetch the details for an employee.

b.  You will see the Department description such as Administration retrieved into the Department PJF field from the Department file.

4.  Exit the form.

5.  Close the form in the Editor.