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 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.