Hi I have been using this framework for the last few days and I am in awe a fantastic framework. I have come from a strong .net and php framework back ground and wanted to learn python this has already taught me so much!!
I have a question that hopefully can be answered easily and maybe I am overlooking something. I have the smart grid working well however i want to display a reference of a reference eg Vehicle > Model > Make Please bare in mind i am using a legacy db Model #-------- db.define_table('tblmake', Field('MakeID','id'), Field('Make','string'), format="%(Make)s", migrate=False) #-------- db.define_table('tblmodels', Field('Model','string'), Field('ModelID','id'), Field('MakeID','reference tblmake'), format="%(Model)s", migrate=False) #-------- db.define_table('tblvehicles', Field('VehicleID','id'), Field('Registration','string'), Field('Driver','string'), Field('Model','reference tblmodels'), migrate=False) Controller vehiclefields = [db.tblvehicles.Registration, db.tblvehicles.Driver, db.tblvehicles.Model] vehiclelinks = [lambda row: A('View Post',_href=URL("search","test",args=[row.VehicleID]))] vehicles = SQLFORM.smartgrid(db.tblvehicles, orderby="VehicleID Desc", fields=vehiclefields, formname="vehiclegrid", details=False, editable=False, deletable=False,links=vehiclelinks, linked_tables=False) I would like to display the db.tblmake.Make field How can I do this? Can I do this? I have tried adding various combinations but with no luck Any help would be greatly appreciated -- 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/groups/opt_out.