Please Help
I am new to MS Access 2007.
I have been through numerous tutorials - not none tells me exactly how to accomplish this.
I have 3 Tables
Table 1:
Contact ID (PK)
Contact Name
Table 2:
Company ID (PK)
Company Name
Table 3:
Order ID (PK)
Orders
Company ID
Contact ID
I have set up One-To-Many Relationships from Tables 1 and 2 TO Table 3
What I am trying to accomplish:
I want to make a Form with 2 Drop Down Menus: one for the Company and One for the Contacts
I want the Drop-Down Menu for the Contacts to to be Filtered by Only Those who work for the Company That has already been selected.
Please let me know how to do this.
Many Thanks - kesselm
I am new to MS Access 2007.
I have been through numerous tutorials - not none tells me exactly how to accomplish this.
I have 3 Tables
Table 1:
Contact ID (PK)
Contact Name
Table 2:
Company ID (PK)
Company Name
Table 3:
Order ID (PK)
Orders
Company ID
Contact ID
I have set up One-To-Many Relationships from Tables 1 and 2 TO Table 3
What I am trying to accomplish:
I want to make a Form with 2 Drop Down Menus: one for the Company and One for the Contacts
I want the Drop-Down Menu for the Contacts to to be Filtered by Only Those who work for the Company That has already been selected.
Please let me know how to do this.
Many Thanks - kesselm
