Blueprint for Many-to-Many
Update: This is somewhat resolved, through a manual method. See budget's
bundle_kit_item() for examples.
Web2Py doesn't really support Many-to-Many SQL tables.
- even though the t2_membership table is one
It can kind-of do it using Tagging widgets:
These are great for selecting between a relatively small number of options (the second supports the jquery multiselect plugin).
However they aren't scalable (too many elements in large lists).
- Mitigate using Auto-complete?
They also don't have proper referential integrity.
I think the ideal should be something like:
If we can make something generic enough then Massimo will be keen to incorporate it.
jQuery MultiSelect plugin: http://plugins.jquery.com/project/Multiselect
My request to Web2Py list:
Other pertinent posts:
- Multiple Lookup table: http://groups.google.com/group/web2py/msg/b69898ec49dcef71