Check Boxes write to One field

[zrobinso]

I have a form to track Services performed to an Employer. [EmployerID] & [ServiceDate] track services. On any [ServiceDate] you can have any number of the 21 Service boxes checked (Currently 21 separate fields).

I would like to have two separate things happen.

1. Eliminate the need for 21 separate fields. Check a box and it writes the selection name to the Services table. Each box checked would be a separate record.

2. If the form were opened in Edit mode, It would show the Selection names as checked boxes on the form. If unselected the record would be deleted. And other selections could be chosen and added to the table.

Thanks for any help.

 

[rajeessh]

Have this as a single field and group all checkboxes and stored it as a String

111100000101001010101001

Parse it and display?