FM 12 (or 13): How to globally replace multiple checkbox set values in a field record?
A field is set up as a "checkbox set" and gets field value list items from a different table field. Example that in any given record, the user will be presented with these checkbox items:
And, in any given record -- any number of checkbox values can be selected: A, AC, ABD, etc...
User of the database would like to *rename* the checkbox values:
A --> E
B --> F
C --> G
D --> H
But *retain* the fact that the box was originally checked as part of the rename (i.e., think each checkbox value is a user names where the last name of the user has changed through marriage.. So the end result from the above example of 3 records would now read E, EG, EFH for the same 3 records.
The brute force method would be to *add* E, F, G and H as items in the field and then go through each record in the table and manually select the corresponding new boxes and then delete A-D, but that seems like it would be harder than it should be.
(And, of course, just *renaming* A --> E in the original field table removes the checkbox on "A", so that's out -- I would have thought that might have worked, but it does not in FM 13)