how to add a related field many2one?

Question

I have a field on stock_picking table I would like to relate it with stock_move

 _inherit= 'stock.picking' 
 _columns={
        'user_id': fields.many2one('res.users', 'user', select=True),
}

I would like to relate the field user_id with stock_move
I tried this

 _inherit= 'stock.move' 
 _columns={
  'user_id': fields.related('picking_id', 'user_id', relation="res.users", type='many2one', string="user", store=True, readonly=True)
}

any Idea brothers?

Answer 1

You have used wrong model in inherit it should be as follows:

 _inherit= 'stock.picking' 
 _columns={
        'user_id': fields.many2one('res.users', 'user', select=True),
}

 _inherit= 'stock.move' 
 _columns={
  'user_id': fields.related('picking_id', 'user_id', relation="res.users", type='many2one', string="user", store=True, readonly=True)
}