How do I store the results from a checkbox'd field when the field list changes?

[Rich S]

This one's giving me a brain hernia so maybe a seasoned FMP vet has an answer for this one...

I have a field (with about 30 items in it) set up as a checkbox and I want to give the user full authority to edit the list without using "Allow entry of other items" since the new item--entered using "Other..."--doesn't appear in the list when added. Fine there. The problem at that I want to be able to record the checked list of items somewhere so in case the list is changed they still have their stored, original choice selection(s) that can be used in a report.

Example:

List items:

[ ] apple

[x] orange

[x] pear

[ ] banana

If the user decides to remove "orange" and "pear" from the value list, somewhere in the solution those two choices are stored for that record for use later in a report.

TIA for your help!

[David Jondreau]

That's already the default behavior. Try it out. Put two copies of the same field side-by-side, and apply a checkbox to one and leave the other the basic edit box.