Depandable dropdown choices?

  • Thread starter Thread starter Harmannus
  • Start date Start date
H

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
 
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
 
Back
Top