Many2one from two tables
I would like to create a field Many2one get data from two different models (two SQL tables). Still I do not know how to make that content is obtained by a domain. That's why I thought I'd create a SQL view and make the comodel_name the Many2one is this view.
But what happens? Well, when I select a value from the list, Odoo creates a button to navigate to a popup window to display the name of the record. In the screen that is generated by default you can edit the name, and as you are trying to modify the data in a SQL view the system gives errror.
In this model ir.model.access.csv file has read only, you can not create, edit or delete