Show field based on subfield

[Harmannus]

Hallo,

I have a frmBillingHours linked to a tblBilling. This table has a field
employeeID linked to tblEmployee. In the tblEmployee I hava a field
TypeEmployeeID linked to tblTypeEmployee. TblTypeEmployee containts a field
EmployeeDescription: part-time, full-time etc. How can I show the field
EmployeeDiscription on the frmBillingHours?

So a field (locked) on the frmBillingHours that shows the
EmployeeDiscription of a employee based on EmployeeID->TypeEmployeeID

Tried lots of combinations but can't get it to work.

Furthermore:

The frmBillingHours als contains the field TypeHoursID. I want to limit the
dropdown choises based on the TypeEmployeeID field. So how can I use the
field TypeEmployeeID as criteria for the field typeHoursID based on the
value of EmployeeID? The field typeHoursID is linked to tblTypeHours with
HourDescription. The tblTypeHours contains the field TypeEmployeeID.

My tables (simplified)

- tblBillingHours
EmployeeID
TypeHoursID

- tblEmployee
EmployeeID
TypeEmployeeID

- tblTypeEmployee
EmployeeDiscription

-TblTypeHours
TypeEmployeeID
HourDiscription


Thanx in advance for any tips!

Regards,

Harmannus