Employee Data

[meboz]

I have the following table structure:

tblEmployees
EmpID
[Other Info]
CCentreID (the ID of the Cost Centre to which the employee belongs)

tblCCentres
CCentreID
[Other Info]
CCM_EmpID (EmpID of the Cost Centre Manager)
DivID (the ID of the Division to which the Cost Centre belongs)

tblDivisions
DivID
[Other Info]
CGM_EmpID (EmpID of the Division Manager)

Im trying to rebuild the flat-file query, like the flat-file table all the data originally came from.

Could someone please help me with this query?

Id like employee details, the cost centre to which they belong, the details of the manager of that cost centre, the division to which they belong and the details of the division manager.

I know it can be done...

Thanks!!

 

[KenHigg]

Can you just bring down the emp table in the query builder, then bring down the cost center table. The from a second instance of the emp table, link the cost center mgr to that table and bring down that emp data, etc...

???
kh