‘Field 1’ is a radio button list containing 15 choices, so you select a choice and ‘Field 2’ is a radio button list set to ‘use formula for choices’. I have ‘refresh choices on keyword change’ set on ‘Field 1’. 3 of the options from ‘Field 1’ have sub options. Using the following formula, I can’t get the list to be anything but ‘X’.
@If(field1=“Option 1”;“A”:“B”:“C”:“D”:“E”:“F”;
field1=“Option 6”;“G”:“H”:“I”;
field1=“Option 7”;“J”;“X”)
This should be working, but it’s not. Again, I do have the refresh choices on keyword change option set. Help shows the following syntax for list formulas…
@If(Location=“Europe”;“France”:“Germany”:“Italy”:“Spain”;Location=“Far East”;“Japan”:“Singapore”:“South Korea”;Location=“North America”;“Canada”:“Mexico”:“United States”;“”)
The longest option in my list in field 1 is 33 characters.
I have similar formulas working in other databases so I am utterly stumped. Thanks in advance for any advice.