In this step, you will add the predetermined join column Department description to the form iiiMaintEmployVirtuals (Real and Virtual Fields in Employee Table).

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

     a.  Display the Design tab.

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

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

Tip: Select the four virtual fields. Position the mouse above and to the left of the virtual fields. Holding down the left mouse button, drag it below the virtual fields and to the right.

     d.  Release the mouse button, and all the fields will be selected.

     e.  Move the selected fields down using the Ctrl+Cursor key.

     f.  Drag and drop the field iiiDeptDescPJC onto the form above the virtual fields.


 

Note: We don't need to change the form because the FETCH statement uses the Fields(*ALL) parameter. Only use this option when all fields are actually required.

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 has been retrieved into the Department PJC field from the Department table. Once again it is the table OAM which implements this code.

4.  Close the form and close the form in the editor.

  • No labels