I looked for the answer to this and could not find it. What I am wanting to do is create a registration database in which the registrant would pick a certain model year from a drop down. Based on the model year that they choose, they would then choose other options unique to that year. I guess the sub options would be conditional?
For Example
Dropdown
1990
1991
1992
1993, etc.
If they chose 1991, for example, they would have certain fields to complete
Exterior Color
Red
Blue
Green
Pink.....
Interior Color
Black
Brown
White.....
If they chose 1992, they fields would be different
Exterior Color
Purple
Yellow
Tan
Interior Color
Yellow
Tan
Green
Any guidance would be greatly appreciated.