I have a list with a choice column which has muliple choices, so that the user can pick from a selection.
Would like it so that the choice list is updatable (i.e can change the names) at a later date and then any existing item's value for that column are also updated. However currently when the column choice is updated, the value for any previously saved items in the list don't already change.
1) Have a list with a choice column called Country which has two options, UK and France.
2) Add a new item to the list with value of UK.
3) Edit the list choice values meta data so that UK option now is renamed to England.
4) Item added in 2) is still UK.
Is there any way to get the change in 3) to be reflected in all items?