How to reset Valid If / ENUMLIST dependent columns on edit?

[gcor71]

In a form I have two dependent fields: Group and Section (defined as per image).
Selecting a Group from the list shows the related Sections for that Group.
All works well except in one situation where the new Group has no similar Sections to the old.

See walkthrough:

1. Group = City of Portsmouth; Section = Dreadnought.
2. Group = 2nd Portsmouth; Section = blank; “This entry is invalid” - apparently correct because at least one Section must be selected.
3. Group = 2nd Portsmouth; Section = Beavers, Cubs etc; “This entry is invalid” - is not correct.
4. If the user clears the Group (clicks the X in the dropdown) and reselect Group = 2nd Portsmouth and Section = Beavers, Cubs etc; the entry is now valid.

What’s happening and how can I prevent the incorrect “This entry is invalid” at step 3?

I have tested different combinations of Allow Other Values and Auto-complete Other Values for the user_section column, but with no change.

Thanks in advance for pointers or guidance.

[Vincent_P]

hi,

Nice presentation of your problem

I’m not sure, but i see on the last picture the message “unable to save change”. Is that means you have an auto-saved field ? So if it’s right, you change your group and there is no change because no section, next step you activate sections but still in error because your group is still not saved. and when you click on the cross, you change group but now you have some section activate and then no error.

[gcor71]

Thank you for taking a look!

The view is not set to Auto Save, so it wouldn’t seem to be that which is causing the issue.
In case it prompts other suggestions, below are the full details for the View and the two Columns…