Depandable dropdown choices?

[Harmannus]

Hallo,

How can i make a dropdown dependable based on a related subtable (set in
another table)?

So:

I have

tblOrganization
- OrganizationID
- OrganizationName
- Address
etc.

tblOrganizationEmployee
- EmployeeID
- OrganizationID
- CategoryID
- EmployeeName
- Tel
etc.

tblProjectOrganizationID
- ProjectOrganizationID
- OrganizationID
- Projectname

tblProject
- ProjectID
- ProjectOrganizationID
- EmployeeID

How can i limit the choices of EmployeeID based on tblOrganizationID.
Through tblProjectOrganization i know the Organization so it would be nice
if the dropdown only showed the Employees of the Organization defined in
tblProjectOrganization.

Thanx for any help!

Regards,
Harmannus

 

[Michel Walsh]

Hi,


Though a join (in a query, assign the query as row source).

SELECT a.EmployeeID

FROM (Projet As a INNER JOIN ProjectOrganizationID As b
ON a.ProjectOrganizationID=b.ProjectOrganizationID)
INNER JOIN Organization As c
ON b.OrganisationID=c.OrganisationID

WHERE c.OrganizationName= 'Acme inc'




You may find it easier to use the query designer graphical possibilities. It
is just a manner to "draw" lines across the related tables.



Hoping it may help,
Vanderghast, Access MVP

 

[Harmannus]

Hallo,

I will give it a try! Thanx for the reply!

Regards,
Harmannus