Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

1

Many2one from two tables

By
Fernando La Chica Mera
on 10/5/15, 4:05 AM 636 views

Hello everyone,

    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

Regards.

1
Eric
On 10/5/15, 7:16 PM

It means that user account can only read the data on the model.  If you want to be able to edit or create the record, then the user's group will need to have create or write access on that model.  You may grant those privileges to the group on the ir.model.access.csv file. Or you can log into Odoo, then go to Settings -> Groups, and find the group that needs write or create privileges, then grant them there.  After that, you should be able to create new, or edit existing records

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 10/5/15, 4:05 AM
Seen: 636 times
Last updated: 4/8/16, 11:10 AM