[web2py] SQLFORM.grid: show reference table

[Omi Chiba]

I want to show the reference field value ('Name' in Model table) on
the grid instead of the original value (Model_ID in Product table).

Is there easy way to do it ?


Controller
-----------------------
def admin():
    db.Product.id.readable = False
    products =
SQLFORM.grid(db.Product,create=False,editable=False,deletable=False,
paginate=10)
    return dict(products = products)
-----------------------------------------------------

Model
--------------------------
db.define_table('Model',
    Field('Name'),
    Field('Unit'))

db.define_table('Product',
    Field('Part_Number',label='Part Number'),
    Field('Model_ID', db.Model ,label='Model Number'),
    Field('List_Price', 'decimal(13,2)' ,label='List Price'),
    Field('FOB', 'decimal(13,2)' ,label='FOB'),
    Field('Weight', 'decimal(13,2)' ,label='Weight'))
--------------------------------------------------