Step 7. Recreate the Employee Holidays Form

In this step, recreate the Employee Holidays application again to include the virtual column and the predetermined join column.

1.  Open the form iiiMaintEmpHols and display the Source tab.

2.  Delete all the code in the Source tab.

3.  Run the template VL_BASEMNT and include all the columns for the table iiiEmpHolidays.

4.  Make sure the Holiday Duration and the Employee Surname fields are not hidden behind the Holiday Comments multiline edit box visualization on the form.

5.  Compile and execute your form.

6.  Fetch holiday details for an employee and holiday code.

     Note the Holiday Duration and Employee Surname virtual fields.