Odoo Help


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.


many2one can't display tablename and id instead of name

on 2/21/14, 3:23 AM 1,366 views

Hello everyone,

I have created field with many2one field it display like tablename.name,1 in the drop down instead of correct name.

Can any one help me...

Thanks In advanced..



| 5 4 7
Bikaner, India

OpenERP Devloper at SunARC Technology

On 2/21/14, 3:46 AM

Many2one drop box shows relation table column name value or _rec_name field value

  'field_id': fields.many2one('mymodule.relation.model', 'Test'),

check many2one relation model table "name" column is available.


If 'name' column is not available in python file then create

    _rec_name = "field_name"

Thank you very much prakash...

on 2/21/14, 5:23 AM
Krupesh Laiya
On 2/21/14, 5:27 AM

add _id after completing your field name

  • Example:

    `fieldname': fields.many2one('ObjectName', 'Label', help='Help note'),`

make it

 ` fieldname_id': fields.many2one('ObjectName', 'Label', help='Help note'),`

thanks krupesh

on 3/3/14, 8:25 AM

correct the answer.

Krupesh Laiya
on 3/4/14, 4:16 AM

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

0 follower(s)


Asked: 2/21/14, 3:23 AM
Seen: 1366 times
Last updated: 3/16/15, 8:10 AM