Changing existing Values List field to a different Global Values List
In 4.x you could change an existing Values List field (both local and global) to link to a different existing Global Values List. This capability was taken away in 5.x for good reason, as you could do significant damage to your data by changing values lists underneath existing data. However, from time-to-time, as we consolidate applications, we have had the need to relate an existing field to a different GVL. The 'right' answer is to rebuild the field as a new field related to the correct GVL. That can be extremely difficult if you are working on a field that is deeply embedded in Calculations and DDEs.
Does anyone have a clever way to do this besides rebuilding the field? Or is there back-room magic that can be done?
Thanks in advance for your thoughts on this...