Hi.
Help, I’m being a bit of an Idiot.
So we have say 200 products. One of the fields within products is a drop down box for if a customer has this product, with yes / no / no reason a / no reason b / etc…
In each account I want to be able to select multiple products. Which I can do from the products subpanel.
What I want to do is for each account be able to select these and also select a different reason from the drop down list.
I do this when selecting them from the product subpanel. BUT then the drop down selection for the reason they took or didn’t take that product is for that product.
So if i add the same product to a second customer and change the reason for this customer that changes the reason for ALL Customers.
How do I do it so that they are independent so it’s the product associated with that account with x Reason from the drop down list. instead of all accounts linked to the one product.
I have a many to many relationship. Do I need to delete this and do a 1 to Many Relationship from within Accounts or is this just not possible. <---- Is this the simple answer
I’m a bit stuck 
Help.