You need to sign in to do that
Don't have an account?
Anup Kabra 2
Need advice on creating many to many relationship on Accounts
Hi All, I have a requirement where I need to create many to many relationship between Accounts. I know this can be achieved by using Junction or Intermediate object but I don't want two related list to show up on Account detail page.
For example: If Account A is related to Account B and Account C, Detail page of Account A should have one related list showing details of Account B and Account C. Similarly, Account B and C should have details of Account A on it detail page.
I tried using Intermediate object with two lookups for account but it returns two related list on account detail page but I need only one.
Is there any way we can achieve this. Also, are there any apps on appexchange which can perform this task?
For example: If Account A is related to Account B and Account C, Detail page of Account A should have one related list showing details of Account B and Account C. Similarly, Account B and C should have details of Account A on it detail page.
I tried using Intermediate object with two lookups for account but it returns two related list on account detail page but I need only one.
Is there any way we can achieve this. Also, are there any apps on appexchange which can perform this task?
May I suggest you please check the below link for reference.
- https://success.salesforce.com/answers?id=9063A000000iSKFQA2
- https://stackoverflow.com/questions/11436056/creating-many-to-many-relationship-between-the-accounts-records-in-salesforce
Hope it helps.Please mark it as best answer if the information is informative.
Thanks
Rahul Kumar
Hi Anup,
Yes, your requirement can be by using Junction or Intermediate object.
If you don't want two related lists to show up on Account detail page for this you can change the layout form the Object.
Open the Record in the object in classic -> Click on the Arrow on the Right Side -> Edit Layout -> and remove that List from related List.
Screenshot :
Hope it Helps you. Please mark this as solved so that it gets removed from the unanswered queue which results in helping others who are encountering a similar issue.
Regards ,
Suraj
Creating relationship between TestAcc1 and TestAcc4 using Junction object:
If I go to detail page of TestAcc1, I should see details of TestAcc4 in the related list:
Similary for TestAcc4 details page should show TestAcc1 in the related list:
Now if I remove, one of the related list from page layout, I won't be able to see the details in the other account details page. I hope I was clear.