Page History
...
| Info |
|---|
| LANSA |
...
| uses |
...
| access |
...
| routes |
...
| to |
...
| describe |
...
| relationships |
...
| between |
...
| tables |
...
| in |
...
| a |
...
| database. |
...
| Access |
...
| routes |
...
| are |
...
| simply |
...
| descriptions |
...
| that answer |
...
| questions |
...
| such |
...
| as |
...
| "How |
...
| do |
...
| I |
...
| access |
...
| the |
...
| associated |
...
| records |
...
| in |
...
| table |
...
| B, |
...
| given |
...
| that |
...
| I |
...
| have |
...
| a |
...
| record |
...
| from |
...
| table |
...
| A?" |
...
| They |
...
| have |
...
| no |
...
| physical |
...
| impact |
...
| on |
...
| the |
...
| database. |
...
A |
...
| predetermined |
...
| join |
...
| column |
...
| (PJC) |
...
| [previously |
...
| a |
...
| predetermined |
...
| join |
...
| field |
...
| (PJF) |
...
| ] |
...
| is |
...
| a |
...
| special |
...
| kind |
...
| of |
...
| virtual |
...
| field |
...
| based |
...
| on |
...
| access |
...
| routes |
...
| whose |
...
| value |
...
| is |
...
| determined |
...
| by |
...
| a |
...
| field |
...
| in |
...
| another |
...
| table. |
...
| (Ordinary |
...
| virtual |
...
| fields |
...
| are |
...
| always |
...
| based |
...
| on |
...
| fields |
...
| within |
...
| their own |
...
| table |
...
| definition.) |
...
Objectives
...
- To create an access route to define the relationships between the Department and Employee tables.
- To show how to create and maintain predetermined join columns (PJCs).
- To add a calculated predetermined join column to the Department Table based on the Columns in the Employee table.
- To add a table lookup Predetermined Join Column to the Employee Table based on the columns in the Department table.
To achieve these objectives, you will complete the following:
Step 1. Understand the Database Relationship
Step 2. Create Access Route from Department Table
Step 3. Create Access Route from Employee Table
Step 4. Create Fields in the LANSA Repository
Step 5. Add Table Lookup PJC to Employee Table
Step 6. Test New PJC in Employee Table
Step 7. Add PJCs to Department Table
Before you Begin
In order to complete this exercise, you must have completed the previous exercises.