Isn't that the same model? On Monday, April 29, 2013 11:31:17 AM UTC-4, Michael Hall wrote: > > > My bad, the model in my example should be: > > db.define_table( > 'contact', > Field <http://www.web2py.com/examples/global/vars/Field>('name'), > Field <http://www.web2py.com/examples/global/vars/Field>('address'), > format = '%(name)s') > > db.define_table( > 'courses', > Field > <http://www.web2py.com/examples/global/vars/Field>('student_id',db.person), > Field <http://www.web2py.com/examples/global/vars/Field>('course_name'), > Field <http://www.web2py.com/examples/global/vars/Field>('pass_mark', > 'text'), > format = '%(name)s') > > > On Monday, 29 April 2013 13:32:10 UTC+1, Michael Hall wrote: >> >> I would like to have a smartgrid that references its parent table in >> linked_tables, what is the web2py way of doing this? I have found some help >> in this thread: >> https://groups.google.com/forum/?fromgroups=#!topic/web2py/vDGJdct550Qbut >> the solution is a bit sketchy due to it modifying sqlhtml.py. >> >> Lets take this model: >> >> db.define_table( >> 'contact', >> Field <http://www.web2py.com/examples/global/vars/Field>('name'), >> Field <http://www.web2py.com/examples/global/vars/Field>('address'), >> format = '%(name)s') >> >> db.define_table( >> 'courses', >> Field >> <http://www.web2py.com/examples/global/vars/Field>('student_id',db.person), >> Field <http://www.web2py.com/examples/global/vars/Field>('course_name'), >> Field <http://www.web2py.com/examples/global/vars/Field>('pass_mark', >> 'text'), >> format = '%(name)s') >> >> >> >> I want a smartgrid for courses that shows all the courses records and has >> the contact table in linked tables. That way I have an easy way to view all >> course data and easily check out the contact data of the person doing the >> course. This smartgrid is used by people who mark courses and require quick >> access to the data in the courses table without having to go via the >> "contact" table. >> >> In a perfect world I would create this smartgrid like so: >> def courseview(): >> form = SQLFORM.smartgrid(db.courses,linked_tables=['contact']) >> return locals() >> >> However this does not work because the contact table is the parent. >> >> What is the best way of achieving my required result? >> >>
-- --- 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.