Hi,
I have a multi-select field that I want to change the name of the list of choices, but without losing all of the data associated with the current name. It should just be a "rename" process rather than a "delete and add new" process. Previously, when I changed the names of the choices, any boxes that were checked immediately lost their value.
To give you an example, say I have three choices: low, med, high
I want to change the names of these choices to: 1, 2, 3 (respectively)
But I want all of the records that are checked with "low" to automatically be checked with a "1," and so on.
Please let me know if anyone has any tips, thanks!