Skip to main content

Notifications

Microsoft Dynamics CRM forum
Suggested answer

Mapping many-to-many relationship within CRM

Posted on by 54
Hi! I'm currently working on adding new entities to our CRM environment, one being customer contracts and the other being manufacturers. I set up a many-to-many relationship between the two, and my end goal is a contracts form where our employees can select the manufacturers on that specific contract. However, I can't figure out how to map within CRM. Does anyone have any experience with this? Thanks!
  • CalebG Profile Picture
    CalebG 54 on at
    Mapping many-to-many relationship within CRM
    Aren't subgrids just views though? I don't believe I can allow the end user to select specific records to relate back to the main form.
  • Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    Mapping many-to-many relationship within CRM
    Hi Partner,
    A subgrid exists within a main form and let app users view data within a Dataverse table, typically related to the record currently being reviewed.
  • CalebG Profile Picture
    CalebG 54 on at
    Mapping many-to-many relationship within CRM
    Hi Leah,
     
    Sorry, mapping may have not been the right word. I want contracts to be a form in Dynamics where users can add the related manufacturers to a field.
  • Suggested answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    Mapping many-to-many relationship within CRM
    Hi Partner,
    Mapping? many to many relationship?
    But mapping feature is only support 1:N(one to many) relationship:
     

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,867 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,173 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans