troubleshooting Question

Trouble With Three Dependent Drop Down Boxes - Using ASP, Javascript, AJAX

Avatar of DanielR6
DanielR6Flag for United Kingdom of Great Britain and Northern Ireland asked on
JavaScriptASP
20 Comments1 Solution665 ViewsLast Modified:
Hi,
I know this question has been answered in various ways, though there never quite what im looking for. Im happy to receive help/solutions in any combination of asp/ajax/javascript. Some advice on which option would be best, i've seen javascript examples where all the data is collected and all the options are done in one hit, or asp where after each selection is made a call back to the server to update the next box is done. My database will pull out up to 500 records maximum.

So this is what I'm trying to achieve;
( Currently all this is in the one table, I have seen examples that use seperate tables and join them, but due to limited knowledge i've been unable to modify them)

From the Access table there are three select boxes that I need to populate;

1st Select Box = Manufacturers
Gather all manufactuers, only need one of each name, so I did try SELECT DISTINCT

2nd Select Box = Models
Gather all models in relation to the selection made in Select Box(Manufacturers). Again only show one of each model

3rd Select Box = Deriative
Similar to the others grab all deriatives that relate to the selection made in Select Box(Models)

I have found something here on EE which maybe what I'm looking for, but I seem to get a javascript error. i would post the code but it is in EE Members only, the link, https://filedb.experts-exchange.com/incoming/ee-stuff/4370-dbfun_ajax.zip.

Advice or good examples of this would be appreciated

Dan
ASKER CERTIFIED SOLUTION
b0lsc0tt
IT Manager

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 20 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 20 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros