Method:Classic General Q&A

Re: Relationship between 2 fields

Method_Justin — Wed, 07 Jan 2015 14:54:19 GMT

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

Re: Relationship between 2 fields

Marcelo11756 — Tue, 30 Dec 2014 21:29:44 GMT

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

Re: Relationship between 2 fields

Method_Justin — Tue, 30 Dec 2014 18:47:20 GMT

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

Relationship between 2 fields

Marcelo11756 — Tue, 30 Dec 2014 16:25:37 GMT

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)