Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / N:N Relationship
Customer experience | Sales, Customer Insights,...
Answered

N:N Relationship

(0) ShareShare
ReportReport
Posted on by PS10 8

In our existing functionality we have two entities, say A and B with relationship as defined:

A (1) : B (N) ---> we use this to to show quick view of entity A on entity B's form. 

A(N) : B(1)----> We use this to display a lookup of B on entity A's form. 

Now, we want to be able to display a subgrid of B on A and A on B, for which i want to delete the existing relationships and create manual N:N relationship by creating a new entity C like: A(1):-> C (N) : <-B(1)

My question what should be the steps to create N:N relationship:

1) Shall i first create the new N:N relationship OR I have to first delete the existing functionality and relationship before. 

2) What will be the impact on the exitsing process if i break the 1:N relationships, how can i assess the impact. 

Any kind of pointers will be helpful. 

Thanks,

PS

  • PS10 Profile Picture
    PS10 8 on at
    RE: N:N Relationship

    Hi Bipin,

    Yes i can add subgrids.

    Let me explain the functionality.

    Current functionality:

    B of type Primary can have only 1 A always

    B of type Non-Primary is curently shown as lookup on A

    New Requirement:

    B of type Non-Primary should be shown as a subgrid on A and users should be able to add many Non-Primary B records

    However, as soon as i add 1st Non-primary B, it gets attached to A which is wrong.

    So to overcome the issue i thought i should get rid of 1:N relationships and instead use N:N.

    Please feel free to ask back if you need any more info on my requirement or if you still think there is a way we can achieve the above.

    Thanks,

    PS

  • Suggested answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,077 Super User 2024 Season 1 on at
    RE: N:N Relationship

    Hi Bipin Kumar,

    Are you familiar with the database anomalies? Whe we are not creating the N: N relationship? If Not then please read out them first.

    If I answer your question then please mark it as verified.

    Let me know if I can provide you with more details.

    Thanks
    Regards,

    Abdul Wahab
    Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
    Direct/WhatsApp:+923323281237
    E-mail: abdulwahabubit@outlook.com
    Skype: abdul.wahabubit
    Linkedin: www.linkedin.com/.../

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,959 Super User 2024 Season 1 on at
    RE: N:N Relationship

    Hi,

    Update...

    You should create N:N relationship between two tables.

    You have two option to create N:N relationship -

    Oob N:N relationship

    Manual N:N relationship 

  • PS10 Profile Picture
    PS10 8 on at
    RE: N:N Relationship

    Thanks Abdul, i am going to try this out in our test environment hope it is as easy as it sound. :)

  • Verified answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,077 Super User 2024 Season 1 on at
    RE: N:N Relationship

    Hi PS10,

    There is no sequence to follow whether to create a new N: N manual relationship first or delete previously created 1:N and N:1 relationships.

    If you want to fix your data then create a manual N: N relationship first. Fix your data then delete previously created 1:N and N:1 relationships.

    How can you access the impact... Impact on data?  If Ye it is already discussed above.

    If I answer your question then please mark it as verified.

    Let me know if I can provide you with more details.

    Thanks
    Regards,

    Abdul Wahab
    Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
    Direct/WhatsApp:+923323281237
    E-mail: abdulwahabubit@outlook.com
    Skype: abdul.wahabubit
    Linkedin: www.linkedin.com/.../

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,904 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,605 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans