Can I create a model out of the relation table in a many2many relationship?

Question

Hi, when creating a many2many relationship like in the following example.

'tag_ids': fields.many2many("task.tags", "task_tags_rel", "task_id", "tag_ids", string="Task Tags"),

The framework creates the relation table "task_tags_rel". As a result, I don't have any model for that particular table as I have for the rest of the others.  I need to have some extra fields in the relation table  "task_tags_rel" as a result of that relation allowing me to have a model I can create a view for. Can I crea

Leonardo Donelli · Answer

Just create the model you need, and give it a one2many field for table A and one2many field for table B. Your model will then be your many2many link between table A and table B, if you want tou can even write some methods to get all Table B record ids given a Table A record id and viceversa.

Related Posts	Replies	Zobrazenia
What's the difference between sale_order and sale_order_line? Solved model	3 nov 24	30245
ODOO V16 Associate Parts to a Finished Good many2many	1 feb 24	2174
How can i set 'res_model' when saving 'ir.attachment'? attachment many2one many2many model	2 nov 23	7214
Custom Model Data in Many2many field without storing in Database many2many	0 júl 24	3231
Why a new record is creating when selecting in Many2Many field many2many	0 júl 22	60

This question has been flagged

Enjoying the discussion? Don't just read, join in!