LANSA uses access routes to describe relationships between tables in a database. Access routes are simply descriptions which 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 its own table definition.)
To achieve these objectives, you will complete the following:
Before you Begin
In order to complete this exercise, you must have completed the previous exercises.