Check Boxes to create a new record in an associative entity?
I have a table/layout called "Contract" which I'd like to have checkboxes on for options from the "Options" table. I created an associative entity, "Equipped Options", that links a contract ID with option IDs. The list of options comes the options table, and the data is displayed from equipped options. The problem I've ran into is the when I check multiple options they all get put into the same field in the "Equipped Options" Table. Is there an easy way to have these check boxes create a new record in the "EquippedOptions" table when checked and delete that record when unchecked?
Also, once I complete this step, instead of displaying the optionID next to the check boxes I hope to use a value list to display the actual description of the option.