Skip to Content
This question has been flagged
fieldrelationshipcustom
1 Reply
5879 Views
Avatar
Pangeran arjuna

Hallo everybody, please be kind and let me know, how to link a custom field from two tables/models, for example a new field from res.partner in sales.order

my case, I add a new field, family_name, in res.partner and then I want to call that field in sales.order. I did, many2one relationship in model sales.oder. but, it doesn't show the value.

Please show me how it works and wish you have a good Karma. Thanks In advance

Avatar
Discard
Avatar
Sudhir Arya (ERP Harbor Consulting Services)
Best Answer

For that you can use fields.related in sale.order.

Try this:

' partner_family_name': fields.related('partner_id', ' family_name', type='char', string='Partner Family Name', readonly=True, store=True),

fields.related is a field that points to some data inside another field of the current record.

Example:

_columns = { 'partner_id': fields.many2one('res.partner', 'Partner'), 'partner_name': fields.related('partner_id', 'name', type='char', string='Partner Name'), }

Here Related Field you can find more about fields.related.

Avatar
Discard
Pangeran arjuna
Author

Hi Sudhir thank you so much for your respond. I'm not programmer. I do customizing in the Web platform. So I add a new field x_family_name which is custom field. How do I do that in the Setting? hope you can help me. Thank you!

Related Posts Replies Views Activity
I want to custom customer form field but the custom is also followed on the vendor form field
field custom vendor
Avatar
Avatar
1
Jun 23
1194
How to add a custom field in address?
address field custom
Avatar
Avatar
1
Apr 23
9793
STUDIO - Duplicate custom field from a sales order to the invoice
field custom Studio
Avatar
1
Jun 22
1405
ERROR: Field does not exist Solved
field custom odoo8
Avatar
Avatar
2
Aug 20
7228
How to pass custom field value from account.invoice to account.invoice.line on Create() method? Solved
invoice field custom
Avatar
1
Nov 19
4220