I have a person table, with names, and a contact_method table, with a name column and a very few rows (Work, Home, Cell, Email). Finally, I have a contact table that contains person ids, contact_method ids, and the phone numbers, etc, that go along with them. I want to create a view that looks like this:
Name | Work | Home | Cell | Email John Doe | x123 | | | [email protected] Jane Smith | x456 | | | [email protected] It is important that we have the ability to occasionally add contact methods (IM, Twitter) without having to modify the database, so creating new columns in the person table is not feasible. I did someting similar to this using Perl several years ago, but I'm having trouble figuring it out in web2py. Can someone point me to an example or otherwise help me out? Thanks. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" 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 -~----------~----~----~----~------~----~------~--~---
