I have two tables that I'd like to link in SQLFORM.grid. db.define_table('customer', Field('firstname'), Field('lastname'), Field('account'))
db.define_table('survey_data', Field('customer_id', 'reference customer'), Field('Q1'), Field('Q2'), Field('Q3')) In my SQLFORM I'd like to only show the firstname, lastname, and a link to view the survey_data for customers who have survey data. def customer_view: query=((db.customer.account > 100) & (db.customer.id==db.survey_data. customer_id)) fields=[db.customer.firstname, db.customer.lastname] grid=SQLFORM.grid(deletable=False, editable=False, paginate=100, query= query, fields=fields) return dict(grid=grid) Is there any way to add a link to view the survey data to this table? I want it to work the same way that clicking 'view' on the SQLFORM.grid automatically brings up a formatted customer information page. Thanks! -- 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.