Announcements
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
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
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/.../
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
Thanks Abdul, i am going to try this out in our test environment hope it is as easy as it sound. :)
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/.../
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,186 Super User 2024 Season 2
Martin Dráb 227,996 Super User 2024 Season 2
nmaenpaa 101,148