I want the 'format' for the dropdown when I create a 'run' entry to be 'manufacturer.name model.model shoe.purchased'
e.g. 'Mizuno Wave Rider 10-11-2014' for instance where 'Mizuno' is the manufacturer name, 'Wave Rider' is the model.model, and the date is shoe.purchased I managed to get the 'shoe' table definition to represent the model and date with a lambda, but I don't know how to include the manufacturer name from the 'model' table parent. So the question is, how do I change the lambda on the 'shoe' table to pull entries from its parent, and grandparent? I only managed the parent table so far. Thank you Here are my models: db.define_table( 'manufacturer', Field('name'), format = '%(name)s') db.define_table( 'model', Field('manufacturer', db.manufacturer), Field('model'), format=lambda r: '%s %s' % (db.manufacturer[r.manufacturer].name, r.model)) db.define_table( 'shoe', Field('model',db.model), Field('purchased','date'), Field('price','integer'), format=lambda r: '%s %s' % (db.model[r.model].model,r.purchased)) db.define_table( 'run', Field('run_date','date'), Field('run_time','time'), Field('run_event'), Field('run_distance','integer'), Field('run_calories','integer'), Field('shoe',db.shoe), Field('race','boolean'), format = '%(rundate)') -- 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.