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.

you don't need table3.

The department code (from table1) is part of the employees demographic data. So you can run a query from table2 (linked to table1 to get the full name) to give you all the employees for a selected department.

Col