Value List or Calculation
I am struggling with using value lists. I have some cascading fields that I want to restrict the value list in the next field based on the value in field number 1. For example- Field #1- is Sport. I have a value list that contains: Football, Basketball, Baseball and etc.
I would like Field #2 to change based on that value selected in Field #1- ie if Football is selected then the Value List would be NCAA, NFL, CFL.
I Then have other fields that would cascade down.
I am not sure whether I should be trying this with value lists or calculations or what.
Any help would be greatly appreciated.