Help required !!!!!

[mahsanzafar]

Hi All,

I am new to Acess 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 an other table 2 for employees i.e., Z, X, Y and so on and their departments from table 1.

There is an other table where I have to select employee from table 1 and their respective department.

All I want (in table 3) is:

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

I believe there whould be some query that need to be build???

Thanks is advance.

 

[lovemuscle2005]

You need to build a simple select query, you can do this by using the query wizard.

Firstly though you need so set a relationship between the tables