Many to Many Usable Portals

[mahonia]

I have people and organizations, and I need to be able to pull up a person and find out what orgs they're with and pull up the orgs to find out what people are members.

The part I can't figure out easily:

I want to be able to directly add organizational affiliations to individuals, by name, from organizations previously listed in the DB. Also vicea versa, adding directories of individual members to records of organizations.

It'd be great to have a value list displayed when trying to add an affiliation to the portal (i.e., pre-existing choices of orgs and individuals) too!

[Kent Searight]

Hopefully this will help.

PeopleOrgs.zip