Hi,

Either you can use the related field concept as stated in the other answer or you can create a new view using the query.  For creating a new view using the fields of different models, see this answer : how do set multiple models in single form view ?

Thanks

You can introduce new fields in this model from another model using the 'related' attribute in the model. An example for relating a partner name using the field 'user_id':

nickname = fields.Char(related='user_id.partner_id.name', store=True)