Relational dropdown list issue

[morespamforya]

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?

 

[pbaldy]

Is this what you want?

http://www.baldyweb.com/CascadingCombo.htm

 

[morespamforya]

Is this what you want?

http://www.baldyweb.com/CascadingCombo.htm

Wow that was really quick

Thanks

I am not sure but looking into it now

 

[morespamforya]

Thanks a lot, that's exactly what i needed

 

[pbaldy]

Glad it helped you.