Hi all,

I am not a DB expert, but am sure there are some in here. I am trying
to a many-to-many(-to-many?) relationship. I would like both
organisations or individuals to be members of committees. Some people
are members of organisations, independent of etiher's membership of a
committee.

Will something like this work?

db.define_table('people',
                      Field('name'))

db.define_table('organisations',
                      Field('name'))

db.define_table('inter_agency_committees',
                      Field('name'))

db.define_table('membership',
                      Field('person', db.people),
                      Field('organisations', db.organisations))
                      Field('committee',db. inter_agency_committees))

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to