db.define_table('voyageur',
Field('Nom'),
Field('Prenom'),
Field('Usuel'),
..
Field('Scolarisation'),
Field('Dpt')
)
db.define_table(
'presence',
Field('Nom_id',db.voyageur,writable=False),
Field('present_le',type='date'),
Field('terrain',requires = IS_IN_DB(db, 'terrain.lieu', '%(lieu)s',zero=T('choose one')))
)
controller:
def index():
form = SQLFORM.smartgrid(db.voyageur)
records = SQLFORM.smartgrid(db.voyageur,linked_tables=['voyageur','presence'],user_signature=True,maxtextlength=100,deletable=True,\
editable=True,create=True,showbuttontext=False, paginate=200, buttons_placement = 'left',links_placement = 'left')
When i click on "presence" i 'd like to see Non (from voyageur table) instead of Nom_id, how can i do with represent i think
thanks in advance , regards