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
Transform Your Team: How to Operate Efficiently and Effectively
The Blueprint for Efficient Team Management

August 15, 2024 | 01:00 PM - 02:00 PM PT
Sage Intacct 2024 R3 Release Overview Webinar
Gain Insights to the latest release features and enhancements

August 14, 2024 | 01:00 PM - 02:00 PM PT
Ask An Expert Series – Workday Adaptive Planning
Don't Miss! 30 Minute Workday Q&A Sessions with Experts

July 30, 2024 | 10:00 AM - 10:30 AM PT