Linking tables on a form

[glinch]

Hi all, I'm becoming a little stuck here



I have 3 tables

tblCompanyName -> tblCompOffice -> tblEmployee

tblCompanyName: Consists of
CompID
CompName

tblCompOffice:
OffID
CompID
...various details

tblEmployee:
EmpID
OffID
....various details

So if its not clear the relationships are: A company can have many offices, Any office can have many Employees

My problem is this:

I have an employee form:
I would like this form to show the Company Name of the employee
(accessing it from the OffID Primary Key)

How do I work backwards so to speak with query to do this, or should I include a CompID field in the tblEmployee.
Would this be bad practice and a repetition of data?

Thanks in advance for any help

[ConneXionLost]

In your query, use all three tables and show the CompName field there. It will then be available to your form for display.

[glinch]

cheers pal thats helped