I do not see any relation between courses and contact. On Monday, 29 April 2013 07:32:10 UTC-5, 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.
