I have 2 choice fields in a list, with the following values
--1 FoodTypes has 5 values (Vegan, Dairy, Meat, Veges, Fruit)
--2 FoodItems has 9 values (Soy, Milk, Cheese, Hamburger, Pork, Brocc, Squash, Apples, Oranges)
What I want to do is overwrite the choice field values for 'FoodItems' column if someone selects 'FoodTypes' of Fruit, and only show the 2 values in 'FoodItems' of Apples + Oranges.
If a users selects Vegan, Dairy Meat or Veges, show all 9 values in 'FoodItems'...we only need FoodTypes==Fruit to pair down the FoodItems choice column.
I've looked at options to change these columns from choice to lookups, but was have dependencies on this list and copies going to other lists.
*** UPDATE : Was able to get this working, but if you mis-select FoodTypes = Fruit...and I meant to select 'Vegan', I still only have the 2 values in FoodItems associated to Fruit.