Drop down boxes from multiple data sources

[Martynrbell]

Hi all.

I am trying to create a linked drop down box on an order form

For example on my order form I would select a drop down for my brand.
This would then limit the next drop down box to the models in the brand.

the third drop down box would show the product code linked model.

In my example I am using cars.

Box 1 - Vauxhall ( drop down )
Box 2 - Astra ( drop down)
Box 3 - Product code (drop down or auto populate)

If i give some sample data to work on .

Ford
focus - FG101
Fiesta - FG100
Mustang - FG105
Mondeo - FG101



Vauxhall
Astra - FG108
Corsa - FG100
Insignal - FG105
Adam - FG101



Here is have the make and models and in bold is the Product code associated with the model.


If anyone has any insight on how to do this i would be greatful

Thanks

Martyn

 

[dmt32]

Hi,
have a look here:https://www.contextures.com/xlDataVal02.html

Provides step by step guide for creating dependent lists & you can download free sample file.


Dave