REP009 - Access Routes and Predetermined Join Columns

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

Step 8. Modify Test Form

Summary