Many to Many, but distinct values

I have a FORM entity and a CATEGORY entity. When a FORM is filled out, users have to pick one or *more* categories. Hence, why it's a MANY TO MANY relationship.    However, for each CATEGORY I pick for a form, I want the users to be able to select an ENUM to pick a Yes/No/NA option. However, with a many to many situation, if I change the value for "Category1" to "Yes", wouldn't all forms with "Category 1" selected be set to "Yes"?    Is there an easy way to set it up so each referenced CATEGORY option on a form can have its own separate answer for CATEGORY? The CATEOGORY has to be an entity and not hard-coded because they change a lot.
0 answers