Method Community

How can I create to dropdown fileds that are related.

For example 

I want to create a screen for equipment, when I choose the make (ford, chevy, etc) in the first dropdown field, I want the next dropdown field to show models for the make only ( F250, F350)

Hi Marcelo,

You can filter your second dropdown (Model) on Step 5 of the Dropdown Properties in the screen designer. You can filter it to only show only Models that have the Make selected in your first dropdown.

Hope this helps.

- Justin

I am not following the logic

Do I have to create tables for each make and then linked them.

One table for all the Fords models, a different table for all the Chevy Models, etc

Hi Marcelo,

Sorry for the late reply, I initially missed this. I created a table for makes called CarMake and a table for models called CarModel. I then added a required dropdown field Make to the CarModel table, which created the link between the two tables.

Hope this helps.

- Justin