Doh did it again, its been a long day, the model with the correct reference
is
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.contact),
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.
