3 values selection relationships and tables

[wattmhite]

Hi All,

I have a data set that includes about 300k records. Each record includes 3 fields: Year, make, Model.

I'm looking to set up the 3 fields in my main database so I can start selecting the year, which will limit what makes are displayed. Select the make and based on the year and make show the available model options.

What is the best way to set up tables and or relationships so this is sorted properly?

Thank you!

[siroos12]

This below link might help:

 

 

http://help.filemaker.com/app/answers/detail/a_id/5833/~/creating-conditional-value-lists

[comment]

18 minutes ago, wattmhite said:

What is the best way to set up tables and or relationships

What is the eventual purpose of making these selections? If it's just for viewing, then you don't need any additional tables - only 3 global fields and a couple of additional occurrences of the existing table.