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!
You can use the previous dropdown selections to create a query filter. Thet appropriate field of the results of that query would then be used for the "next" dropdown. Duplicates can be eliminated by following the Example: Remove duplicates from connected dropdown options.
As Ethan points out, you will need some significant code for this, but it seems to me that it's doable.
The reason you cant find a solution, Sadly, Is there is no Easy solution for this. This would take a bit even for me to set up.. I see a way it Could be done getting all the info top down but still it would take a lot of code.