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 [email protected].
For more options, visit https://groups.google.com/d/optout.
