I've been struggling to find a direct solution for a very specific issue.
What I am trying to achieve:
Drop-down 1: Year
Drop-down 2: Make (dependent on year)
Drop-down 3: Model (dependent on year+make)
Drop-down 4: Trim (dependent on year+make+model)
I have a database with year, make, model, and trim options for cars. I need to create a form where the user selects a vehicle year, and then make (dependent on year), and then subsequently the model, and trim. Each option being dependent on the selections of the previous options.
(I don't want "trim: quad cab super duty" showing up for a 2012 Honda Civic).
How can I achieve this while using a single database?
I have found solutions that work great for the first two drop-downs (ie year then make), but these seem to fail as soon as I need a third and forth drop-down.
I am hoping there is an easy solution without writing tons of code.
I appreciate any help!