I've two models Product and ActiveIngredient
I want to have a many 2 many relationship between above 2 models
It means a product can have multiple active ingredients and an active ingredient can have multiple products
But I also want to store concentration data for specific product and its active ingredient, so I've to add one extra column in intermediate table where it stores productid and activeingredientid
so the intermediate table will be as below:
product_id, activeingredient_id, concetration
Can anyone help me how to achieve that because in laravel it was easy to add any extra column in intermediate table but don't know how to do that in odoo?
I also want user to add that data in product's form view.