I am just guessing these of the top of my head so I may be wrong. but it is at lease
2 Master Details and 20 lookups.
But there is also limits when Querying in SOQL how many times you can select chilren rows and transverse parents. I belive you can go up 10 levels high
I think total 40 Custom Relationship both lookup and master-detail. If any one is sure about the no. of relations then please confirm and share the offical salesforce link or document.
As per Summer 14 the limit has been revisedd to 40 realtionship that can include maximum 2 MD relation for any object. Refer: https://help.salesforce.com/help/pdfs/en/salesforce_summer14_release_notes.pdf Page-239 for details
Total Relationships (including Lookup and Master Detail) on a single object, we can create 40 relationship fields. Number of Relationships you can have is : Number of Lookup = Total Relationships - Number of Master Detail Relationships 38 = 40 - 2
Please mark it helpful, if you found this answer correct.
You can create up to 25 lookup fields in the standard and custom objects both. But you have an advantage in standard objects in that you already have some standard lookup fields. So you can create an extra 25 lookup fields with standard objects. And you can create up to 2 MD fields in custom objects.
If you find your Solution then mark this as the best answer.
I am just guessing these of the top of my head so I may be wrong. but it is at lease
2 Master Details and 20 lookups.
But there is also limits when Querying in SOQL how many times you can select chilren rows and transverse parents. I belive you can go up 10 levels high
I am Confirm that
2 Master Details and 25 lookups we can create in an object.
Form the Spring 13 release onwards, i heard that we can create 3 master-detail relationships. can anyone confirm?
Anil
And we can have 2 Master - detail relationships for only custom object.
Refer: https://help.salesforce.com/help/pdfs/en/salesforce_summer14_release_notes.pdf
Page-239 for details
I confirm the above 100% because Goto Object >> View Objects >> Object Limits >> Custom Relationship Fields = 40
Regards
Amith S Rao
Number of Relationships you can have is :
Number of Lookup = Total Relationships - Number of Master Detail Relationships
38 = 40 - 2
Please mark it helpful, if you found this answer correct.
Greetings!
You can create up to 25 lookup fields in the standard and custom objects both.
But you have an advantage in standard objects in that you already have some standard lookup fields.
So you can create an extra 25 lookup fields with standard objects.
And you can create up to 2 MD fields in custom objects.
If you find your Solution then mark this as the best answer.
Thank you!
Regards,
Suraj Tripathi