Multi-tier Dependent Dynamic Drop-Down

Ask the community
,
1

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!

2

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.

3

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.