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
Women in Life Sciences ESG
Join us for a blooming ESG discussion and a floral arrangement workshop!

July 20, 2022 | 03:00 PM - 05:00 PM PT
Unleash Your Nonprofit’s Fundraising Cloud Strategy
Realizing you need to replace outdated and siloed technology is step one.

July 19, 2022 | 01:00 PM - 01:30 PM PT
Why SaaS Metrics Matter Webinar Thumbnail
Discover how collecting and reporting the right SaaS metrics can help analyze the health of your organization.

July 19, 2022 | 10:00 AM - 11:00 AM PT