thanks Massimo! Let me see if I can get this going via the
SQLFORM.factory--thanks for the suggestion.
--Peter
On Oct 11, 9:37 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
> Something is wrong with this:
>
> db.define_table('dogs',
> ...
> Field('vaccination_id', db.vaccinations))
>
> db.define_table('vaccinations',
> Field('dog_id', db.dogs),
> ...
> )
> there is a circular definition and seems to indicate each dog can have
> a single vaccination.
>
> I would go with this:
>
> db.define_table(
> 'users'
> Field('name')
> )
>
> db.define_table(
> 'dogs',
> Field('owner_id', db.users),
> Field('name'),
> )
>
> db.define_table(
> 'vaccinations',
> Field('dog_id'),
> Field('vaccination')
> )
>
> You can do things like:
>
> form=SQLFORM.factory(db.dogs,db.vaccinations)
>
> but you have to be careful about repeated fields.
>
> If you describe the workflow of what you need to do perhaps we can
> help more.
>
> Massimo
>
> On Oct 11, 6:47 pm, Peter Woolf <pwo...@gmail.com> wrote:
>
>
>
> > Can I create a crud form that simultaneously update multiple rows and
> > multiple tables? I’ve been through the web2py manual a number of
> > times, but don’t see this issue addressed. Below is an example:
>
> > In db.py
>
> > db.define_table(
> > 'users'
> > Field('name')
> > )
>
> > db.define_table(
> > 'dogs',
> > Field('owner_id', db.users),
> > Field('name'),
> > Field('vaccination_id', db.vaccinations)
> > )
>
> > db.define_table(
> > 'vaccinations',
> > Field('dog_id', db.dogs),
> > Field('vaccination')
> > )
>
> > Given these three tables, I want to be create a crud form where I can
> > update the names and vaccinations of all of the dogs of a particular
> > owner. For example, if I have two dogs, muffy and fluffy, then I want
> > to create a form where both the records of muffy AND fluffy are
> > presented in ONE form to allow me to edit the tables ‘dogs” and
> > ‘vaccinations’ with one submit button.
>
> > Any thoughts on how to do this? I can easily make a crud form for a
> > single record, but this would mean I have many submit buttons on a
> > page or a very long series of pages to do something simpler.
>
> > Any thoughts would be appreciated.
>
> > Thanks,
> > --Peter
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
