morespamforya
New member
- Local time
- Yesterday, 16:30
- Joined
- Aug 6, 2010
- Messages
- 7
Hi there, I have a simple 3 table relation, as listed:
1. Company
2. Company Contacts
3. Company Enquiries
Here's a graphical representation of the tables:
They are related as follows:
1. A company can have as many different company contacts as it needs.
2. A company can make an enquiry
3. When a new enquiry is made:
a. the DB user has to choose a company it's associated with.
b. the DB user enters enquiry description
c. the DB user chooses a Contact associated with the company for that enquiry
The problem is, when the user chooses a Contact from a dropdown list combo box, it shows every single contact in the contacts database, where as, it should only show the list of contacts that is associated with the company the user chose in stop (a)
Is there any way for the drop-down list to be filtered by what company the enquiry is related to?
1. Company
2. Company Contacts
3. Company Enquiries
Here's a graphical representation of the tables:
They are related as follows:
1. A company can have as many different company contacts as it needs.
2. A company can make an enquiry
3. When a new enquiry is made:
a. the DB user has to choose a company it's associated with.
b. the DB user enters enquiry description
c. the DB user chooses a Contact associated with the company for that enquiry
The problem is, when the user chooses a Contact from a dropdown list combo box, it shows every single contact in the contacts database, where as, it should only show the list of contacts that is associated with the company the user chose in stop (a)
Is there any way for the drop-down list to be filtered by what company the enquiry is related to?