Armanino Blog

Two Types of N:N Relationships in CRM

December 07, 2009

I recently made use of the two types of N:N relationships available in CRM 4.0:

  • Native N:N Relationship – CRM automatically creates the relationship between two entities.
  • Manual N:N Relationship – A combination of two N:1 relationships that share a common intersect entity.

I created a custom entity to represent network events that I attend at which I meet new or known contacts. I want to track which events I attend and when, as well as the people I have the opportunity to spend some time with during the event. For this I used the native N:N relationship. I just created the custom entity and then created a new N:N relationship with the contact record.

Here's my simple custom entity. The contacts list is represented in the details section as "attendees".

N:N Relationship – CRM Contacts Attendees

Here is a view of the Network Event from the Contact's perspective. If I had met with this contact at several network events, they would all be listed.

N:N Relationship – CRM Events

Here are the details of the N:N relationship that was created by CRM:

N:N Relationship – CRM Details

I also created two custom entities to track which ISV products our clients own. I set up a manual N:N relationship for this because I wanted to not only identify which ISV products a client has, but also some specific information about the product registration, e.g. user count, renewal date, etc.

Here is a diagram of the custom entities and the relationships:

N:N Relationship – CRM Custom Entities

Here is an example of the ISV Product Registration that has specific information about the client's registered products:

N:N Relationship – CRM ISV Product Registration

The product is Mekorma MICR, and the client is A.L. Wizard. There is specific information about the client's registration of this product.

This allows me to easily track ISV product registrations and create workflows and views that help manage this part of our business.

Stay In Touch

Sign up to stay up-to-date with the latest accounting regulations, best practices, industry news and technology insights to run your business.

Related News & Insights
General Contractor Trends to Consider in 2022 Webinar
Hear from experts how you can better manage your subcontracts — and more.

December 16, 2021 | 10:00 AM - 11:00 AM PT
Women in Nonprofit Leadership Panel
Aspiring nonprofit leaders should hear the insightful stories of these women industry leaders to empower their journeys.

December 14, 2021 | 10:00 AM - 11:00 AM PT
The Evolution of Gaming Companies
From seed-funding to acquisition, position your gaming company for success.

December 9, 2021 | 01:00 PM - 02:00 PM PT