Hi Guys, hope you can help.
I have a web base application written with HTML and ASP. However I want to have a combo box function and I really need your help.
I have 2 combo boxes. The first combo box is populated from a MSAccess database. What I want is that on choosing an option from combo box 1, Combo box 2 will be populated from shortlisted items in the database. I already know how to get combo box 1 populated; my problem is how to get combo box 2 automatically populated.
eg. Combo box 1 options : dog, car, house
If a person choose CAR, combo box 2 should automatically populated with items relating to car.
Another note: Combo box 1 will consist of perhaps 8 options. The database has a table of about 70 items, but I just want the ones that pertain to the option choosen in combo box 1 to be displayed as options for combo box 2.
Any assistance will be hugely appreciated.