AnsweredAssumed Answered

FM 12 (or 13):  How to globally replace multiple checkbox set values in a field record?

Question asked by maser on Feb 3, 2014
Latest reply on Feb 4, 2014 by maser

Title

FM 12 (or 13):  How to globally replace multiple checkbox set values in a field record?

Post

     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:

     A

     B

     C

     D

     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)

      

     Any suggestion for a better way to do this?  

Outcomes