i'm not very strong in the sql section and can't find the documentation on postgres view, can you please explain if possible, also can you please elaborate on the fields_view_get + read, sorry i am don't know much about these and can't find the proper documentation for these either

I think that you should use sql view, Because if you do you own field_view_get and read methods you will by pass the BaseModel class, it is the core of OpenERP. If really you need this look for in the magentoerpconnector of Akretion in 6.1, i think they did it.

Thanks for the reply i donot say that i will not do it sql view way, i just want to know both ways, one might be better/faster or maybe only thing required in some case. Thanks for your help. I'll look up the magentoerpconnector