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.