Page History
[ 
|../../index.htm#lansa/repeng01_0065.htm]
You are here:
...
In this step, create an access route from the Employee Holidays table to the Employee Table. The number of records is one.
1. Create a field for the employee surname to be used as a PJC as follows.
Field Name | Field Description | Type | Length |
|---|
iiiSurnamePJC | Employee Surname | Alpha | 25 | Allow LC |
|
2. Define an Access Route to the Employee table, with a key of iiiEmployNumber.
3. Define the Predetermined Join Column to retrieve iiiSurnamePJC from the employee surname (iiiSurname) in the Employee table. This is a lookup PJC.
4. Compile your table to recreate the OAM.
[ |../../index.htm#lansa/repeng01_0065.htm]