I have a Many2one field already works in a lot of records in a production instance, now is needed that this field accepts more than 1 relation link to the other model, is possible just change the field type from Many2one to Many2many without losing any data?
If yes, what's the correct way to do it? if not, how to do it?
Why would you want to change from a many2one to a many2many though?You're most likely better off to create a one2many that links to a many2one - it'll behave the same as a many2many but it has benefits. On a many2many you cannot filter by default and if you export the data you won't get everything out automatically. With a one2many you can. Just a tip. :-)
@Yenthe Your approach it's helpful, I've not even though, so, can I take your answer as If I can change the field from Many2one to One2many or Many2many and the data persist?
I can't use the One2many field because 1 a.object can have N b.object and 1 b.object can be in N a.object, so I should use the Many2many field, but I need to know if the information persists after changing the field type from one2Many to (Many2many or One2many).