Step 1 Understand the Database Relationship

Visual LANSA

Step 1. Understand the Database Relationship

REP009 - Access Routes and PJFs

Before creating an access route, you need to understand the relationship between the Department (iiiDepartments) and the Employee (iiiEmployees) files that you have already created. The company structure is a hierarchy of departments and employees:

Departments

ADM

LGL

TRN

TRV

 

 

Employees

01,02

03

04

 

Departments have employees. An employee cannot exist without the department. Stated another way, the department is the parent or owner of its employees.

Relationships work in both directions. From the perspective of the Employee file, it is the child of the Department. An employee belongs to just one Department.