Armanino Blog
Article

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.

Resources
Related News & Insights
SaaS Market Trends
Webinar
Between the uncertainty of 2022 and the highs of 2021, what will 2023 hold?

December 14, 2022 | 09:00 AM - 10:00 AM PT
Fraud: Current Trends & Hot Topics
Webinar
Don’t let fraud negatively impact your organization.

December 8, 2022 | 11:00 AM - 12:00 PM PT
Year-End Tax Planning for High-Net-Worth Individuals
Webinar
Our tax experts will dive deep into our annual year-end tax planning guide.

December 8, 2022 | 09:00 AM - 10:00 AM PT