Need some Conditional Value list finesse
I have succeeded in getting a conditional value list to work, but not quite as good as I would like. The options chosen in field_one dictate the available options in field_two. That part works good. Where it fails is when one chooses a different option in field_one, but doesn't click in field_two to choose one of the more appropriate options. I need the options available with field_one>choice_one to always be mutually exclusive to the options available with field_one>choice_two, even if no changes are attempted in field_two.
I tried an OnObjectModify script trigger on field_one, but couldn't get that to behave either.