Table 1: Department- Fields: Department, Floor, Code

Table 2: Staff - Fields: Name, Address, Phone, Lookup Field for Department

Form: Employee Certifications Fields: Class, Date, Lookup Field for Department from Table 2, I need a field that holds the Name

In Access I can have a Lookup Field that shows Departments when I select the Department my next Lookup Field only shows me records for the field Name that are in the Department lookup.

If this makes any sense I could use some direction.