• Sign in
    • Try it free

    Help

    3

    Is it possible to create a view which inserts in 2 different tables?

    Avatar
    Yakito
    viewsfieldstreeviewfield

    Hello,

    I am learning how to develop my own modules, and for it I need to create a new view with different pages inside.

    I wish to be able to insert some of the fields in the main table created by the class, and the fields which are inside the page of the view into another table.

    Is this possible? If someone can point me in the right direction I will appreciate it!

    Thanks!

    Avatar
    Discard
    1 Answer
    2
    Avatar
    Andreas Brueckl
    Best Answer

    You can use fields of type related to update fields which are not part of the actual model.

    Here is an example from model stock.move:

    'origin': fields.related('picking_id','origin',type='char', size=64, relation="stock.picking", string="Source", store=True),

    This code maps the origin of the stock.picking to the origin of the stock.move. So you can change the origin field of stock.picking from within the stock.move model.

    Update:

    You can also use a function field and define a method for argument fnct_inv. (See the Developer documentation)

    Comment Share
    1 Comment
    Avatar
    Discard
    Avatar
    Yakito
    -

    Perfect I think this will work. I will test and then come back to mark the answer right. Thanks a lot!