This is a continuation from my last post to include the
results.asp file. Thanks
I have created a search page to search an existing
database for used cars. I have four drop down menus.
Year , Year, Make and Model (all are populated from the
database, the year drop downs are the same (duplicated).
What I need to figure out is how to be able to search a
range between the year dropdowns if "All" is not
selected. Secondly, if a Make is chosen (not "All"
value), I want the fourth drop down menu for the Model to
only show Model's related to the Make chosen in the third
drop down menu.
For Example: If a Make Honda is chosen, I want the
dropdown menu for Model's to only show Civic, Accord, CRV
etc. from the database. Thanks for your help.