I have a table for Registrations and a form associated with it. I would like to have a table for Registration Details. On the registrations form my thought is to have a subform for the Registrations Details. I would like to have the subform have checkbox controls where each control represents an event that can be registered for. When a checkbox is selected it would add a record to the Registration Details table related to that registration, however if the checkbox is deselected I want the record to be deleted.
Basically this is similar to a table of Orders and a table of Order Details. At the moment there will be about 16 checkboxes that can be selected. Afterward the two tables will be used to group the registrants into predetermined groups based on the events selected.
My thought is that the Registration Details table will have three fields as follows: DetailID (Primarky key), RegID (relating to the Registration table), and Event.
Is this possible, and if so how do I go about doing it?
Basically this is similar to a table of Orders and a table of Order Details. At the moment there will be about 16 checkboxes that can be selected. Afterward the two tables will be used to group the registrants into predetermined groups based on the events selected.
My thought is that the Registration Details table will have three fields as follows: DetailID (Primarky key), RegID (relating to the Registration table), and Event.
Is this possible, and if so how do I go about doing it?
