Use a value list using the Name field from you table with names in it. Use this value list for your checkboxes.
You can then have another field that is set to Substitute( textfield; "¶"; ", "). This will work, but need to adjust the UI if your list grows too much.
If you intend to add more values to your value list a recommend you to create a new table and store records for each value. Then you can change the value list through out time but always keep information in related table.
Thanks for the reply.
I thought this initially worked, however it appears to have substituted the checked values in all instances in all records, i.e. not just the record at hand.
Is there any way I can Substitute just the elements in the [current] record?
Is the field you are us no set to global storage? What table is the field in?
The field you create should be in the same table the records are not in, not the table with the list of names.
Although there is a way you can make this work with a relationship, in the simplest use there should not be a relationship between the record table and the name value list table.
Yes, the field I created was in the table with the records, not with the list of names that was being used as a Value List.
Thanks for that file, looking into that and seeing how you've made it work educated me enough to find out what I was doing wrong, and finally get things to work as I wanted. Great stuff.