If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Depandable dropdown choices?
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 |
#2
|
|||
|
|||
Depandable dropdown choices?
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" wrote in message ... 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 |
#3
|
|||
|
|||
Depandable dropdown choices?
Hallo,
I will give it a try! Thanx for the reply! Regards, Harmannus "Michel Walsh" vanderghast@VirusAreFunnierThanSpam wrote in message ... 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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|