Relationships issue

(0) Share

Report

Posted on by Community Member

Problem:

I have Committees to which there are Titles within each one. (member, observer, treasurer,etc)

I need to connect a Contact to a Committee with a specified Title. Some contacts could be in more than one Committee with the same or a different title.

I have created a Committees entity and I have created a Titles entity. The Contacts entity has a N:N relationship with the Committees entity and the Committees entity has a N:N relationship with the Titles entity

I had no issue with relating the Contacts with the one or more Committees and but introducing the Titles has become a challenge.

Here is an example:

John --> Finance Committee --> Observer

John --> Audit and Investment Committee --> Treasurer

John --> Tech Committee --> Chair

Any help would be greatly appreciated

Malcolm

*This post is locked for comments