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 No

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.