Step 3. Concatenation Virtual Column

In this step, you will concatenate the Department field iiiDeptCode with the Employee Number field iiiEmployNumber to set the value of the Full Employee Number field iiiFullEmployNumber.

1.  Select the iiiFullEmployNumber field in the list of Undefined virtuals.

2.  In the Details tab, enter the following:

Virtual Field Type

Code Fragment

Derive value when record is read

Select box for yes

Populate real field when writing to the table



3.  Add the following code to Virtual Field Derivation:
#iiiFullEmployNumber := #iiiDeptCode + #iiiEmployNumber

     Change the code to use your initials.

     Your Details tab should now look like this:

3.  The iiiFullEmployNumber field will now be listed under Read virtuals.