Trying to migrate my old access environment to web2py. I have imported all data, can be viewed ok. Trying to get a dropdown list (when using smargrid) that is a subset of a table. been trying for while now, maybe someone can give me a hint. Here is the tables :
# db.define_table('famille' , Field('famille' ,'string' , label='Famille' , length = 25),format='%(famille)s') # db.define_table('detail' , Field('famille' ,'reference famille'), Field('detail' ,'string' , label='Detail' , length = 60),format='%(detail)s') # db.define_table('achat', # not showing all the fields to shortens the text a bit Field('famille' ,'reference famille' , label='Famille'), # shows as a drop down pick list, works ok Field('detail' ,'reference detail' , label='Détail' ), # show sall the detail, but I would like to view only the ones related to the "famille" that has just been selected Field('dcc' ,'boolean' , label='Payer ce mois')) # # The controler, as it is now: def manage(): db.achat.id.readable=False db.achat.qui.represent = lambda v, r: '' if v is None else (db.qui(v).prenom) db.achat.typ.represent = lambda v, r: '' if v is None else (db.typ(v).typ) db.achat.famille.represent = lambda v, r: '' if v is None else (db.famille(v).famille) db.achat.detail.represent = lambda v, r: '' if v is None else (db.detail(v).detail) grid = SQLFORM.smartgrid(db.achat, linked_tables=['qui','typ','famille','detail','famdet'], fields=[db.achat.quand, db.achat.montant, db.achat.cash, db.achat.qui, db.achat.commun, db.achat.typ, db.achat.note, db.achat.famille, db.achat.detail, db.achat.dcc ], orderby=~db.achat.quand, create=False, exportclasses= dict(csv_with_hidden_cols=False, tsv_with_hidden_cols=False, tsv=False, json=False, xml=False, html=False), paginate=10) return locals() -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.