AnsweredAssumed Answered

Check Boxes to create a new record in an associative entity?

Question asked by BradMorris on Nov 9, 2011
Latest reply on Nov 9, 2011 by BradMorris

Title

Check Boxes to create a new record in an associative entity?

Post

 

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.

Outcomes