Skip to main content

Notifications

Sales forum
Answered

N:N Relationship

Posted on by 428

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 428 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,070 Moderator 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,962 Moderator 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 428 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,070 Moderator 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/.../

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

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

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 227,996 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans