Yeah, been a long day it 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.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')
The reference in the table courses should be db.contact.
On Mon, Apr 29, 2013 at 4:39 PM, Anthony <[email protected]> wrote:
> 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/vDGJdct550Q<https://groups.google.com/forum/?fromgroups=#!topic/web2py/vDGJdct550Q>but
>>> 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 a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/web2py/yWXaGpbH28M/unsubscribe?hl=en.
> To unsubscribe from this group and all its topics, send an email to
> [email protected].
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
---
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/groups/opt_out.
