Hello, I have a form that is to be used to get data from an inventory. The form is to be made up of 6 drop downs. These drop downs are 'Vehicle Type', Make, Model, Trim, Year Ranges (Start and End). I can get the drop down boxes to populate when I first load the site...but have no clue how to change the data in the drop downs based on when you click a drop down.
By default, when you first load the form...I want it to populate the Vehicle Type with the type field in tblCars, all of the current distinct Models from tblCars, and list the distinct years for the two date range drop downs. Then when you select certain certain fields from the different drop downs, it is to populate the others...
I have found a form on the internet of a page that comes close to what I would like, and it is located here:
http://www.communitychevrolet.com/NewVehicleSearch
Has anyone created a form like this? Or can point me in the right direction on building one?
|