Synchronize Two Dropdowns

[ABinBoston]

I have two dropdowns - "select1" and "select2"

select 1 shows a list of Companies, bound by CompanyID

select2 shows a list of Contact names..

I'd Like select2 to be populated with records from the Contacts table where CompanyID=CompanyID when I select a Company from select1.

Also, if I re-select another Company, I'd like the data in select2 to refresh and fill the dropdown with the appropriate names once again.

I have 2 recordsets on the page rsCompanies, and rsContacts.

Any help on how this is done is appreciated.

Thanks! - AB

 

[mlawson]

Take yourself over to Gareth's page at Buzzinet. He has a few tutorials based on this, they are all very well written. The one you want is a 'child menu' system, where conditional entries appear in a child dd list based on the selection in a parent one?

http://ultradev.buzzinet.co.uk/asp/tutorials/child_dropdown/index.asp

Have fun!

M