First page Back Continue Last page Graphics

Dependent List Example


Notes:

Dependent List Example

In this example, imagine a page based on two tables (EMP and DEPT). The EMP table has two foreign keys, one to DEPT and the other a recursive key back to itself. A business requirement has been defined, stating that “All employees must be managed by someone working in the same department as the employee.”

This is a great opportunity to employ dependent lists. When an employee is created and assigned to a department, you should see only the employees from the same department.