Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Many to many N:N relat...
Microsoft Dynamics CRM (Archived)

Many to many N:N relationship is not working with "account" and "contact"

(0) ShareShare
ReportReport
Posted on by Aminovski

Hello everybody!
Actually I am trying to create a new N:N relationship between “account” and “contact”. I wanted to display a subgrid of “contacts” in an “account” from which I can add “contacts” to the “account”. The same “contact” can be added in several account record forms. Unfortunately, the “+” button is not displaying on the “contacts” subgrid so I couldn’t add contacts to any account. I have tryied the same thing between “account” and a custom entity and it does work. The question is, is there any limitation with N:N relationships? (it is not a security role issue because I am a System Administrator)

 

7128.Capture.PNG

*This post is locked for comments

  • Suggested answer
    Patrick Friedrich Profile Picture
    Patrick Friedrich 395 on at
    RE: Many to many N:N relationship is not working with "account" and "contact"

    Hi Amine,

    in the subgrid settings on the account form you have to set the N:N entity.
    In your case it´s called shareholders. So do not choose contact or company in the subgrid.

    I have currently the same setting for another project and I´m facing some issues:

    Normally, a contact has one main company he/she works for. Therefore the parentcustomerid field makes sense. If you try to add another company for the same contact - issues will appearas Wei already mentioned.

    I have the following problem:

    community.dynamics.com/.../754611

    And there is also another thread with different solutions:

    community.dynamics.com/.../127864

    But in my mind, nothing of them works properly. Connections are very basic and not smart I guess. And a custom entity could work but I´m not quiet sure to be honest.

    So it depends on what do you want to do with the N:N Relationship?

    Hope that helps.

  • Aminovski Profile Picture
    Aminovski on at
    RE: Many to many N:N relationship is not working with "account" and "contact"

    Hi,

    Thank you for your answer. Using connections doesn't resolve my problem. I used an intermediate entity instead. But for future purpose, I don't understand why it is not possible to add new N:N relationships between "account" and "contact"??? 

  • Suggested answer
    Alex Fun Wei Jie Profile Picture
    Alex Fun Wei Jie 33,626 on at
    RE: Many to many N:N relationship is not working with "account" and "contact"

    Hi,

    You should use connection instead of N:N relationship.

    Find the explanation here, using N: N for these two entities will cause you a lots of trouble in future.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,321 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans