تخطي للذهاب إلى المحتوى
القائمة
لقد تم الإبلاغ عن هذا السؤال
1 الرد
1182 أدوات العرض

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.

الصورة الرمزية
إهمال
أفضل إجابة

If you need to add extra column between many2many from 2 table, then you can achieved it via:

  1. Add a new table, let say the name of the table is ProductIngredientLine
  2. Add three column into the table:  product_id, activeingredient_id, concetration
  3. Create relation one2many​from Product​ table into ProductIngredientLine​using product_id​ column as  Relation Field
الصورة الرمزية
إهمال
المنشورات ذات الصلة الردود أدوات العرض النشاط
2
أبريل 25
2859
2
مايو 24
4375
1
أكتوبر 24
1473
2
مايو 25
1070
2
يونيو 24
1695