LANSA uses access routes to describe relationships between files in a database. Access routes are simply descriptions which answer questions such as "How do I access the associated records in file B, given that I have a record from file A?" They have no physical impact on the database.
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 file. (Ordinary virtual fields are always based on fields within its own file definition.)
Objectives:
To achieve these objectives, you will complete the following:
Step 1. Understand the Database Relationship
Step 2. Create Access Route from Department File
Step 3. Create Access Route from Employee File
Step 4. Create Fields in the LANSA Repository
Step 5. Add File Lookup PJF to Employee File
Step 6. Test New PJF in Employee File
Step 7. Add PJFs to Department File
Before you Begin
In order to complete this exercise, you must have completed the previous exercises.