Help Required !!!!!

Hi All,

I am new to Access and trying to create a database for employee's leave record.

I created table 1 for departments i.e., A, B, C and so on

There is table 2 for employees i.e., Z, X, Y and linked with table 1 for their departments.

There is table 3 where first I have to select department (from table 1) and then employee (table 2).

All I want (in table 3) is:

Once I select department, the next field for employee show its respective employees.

Thanks is advance.