I have a layout where users can select team members in portal rows, based on a value list of a companies' employees.
Based on the selections, another value list is then created for the "Select SPOC" field on the far right. This value list is based on the selections of team members.
The problem is that if a team is selected, and then "Durham" is selected as the SPOC, this might cause a data problem:
-. If someone selects a different person in Durham's portal row, her name disappears from the value list, but the previous data entry is still in the radio button field, but hidden.
Is there a way to configure a radio button field so that any new entry always wipes any previous values?
Thanks so much for any insights.