+ Start a Discussion
sahitya adminsahitya admin 

limitation of lookup and master detail relationships in all the editions.

Hi ,i would like to know that how many lookup and master detail relationships are allowed on Custom and Standard objects in all the editions.need help thanks in advance.
 
buggs sfdcbuggs sfdc
We can have 40 Look up fields for any standard object and custom object.

And we can have 2 Master - detail relationships for only custom object.
Arvind KumarArvind Kumar
Hi Admin,

Lookup relationship:
You can create 40 lookup relationship for standard & custom Object.

Master - detail relationship:
There is only 2 Master-Detail Relationship allowed per object and it can have up to three custom detail levels. 

As a best practice, don't exceed 10,000 child records for a master-detail relationship.

You can read more about it here, Considerations for Relationships (https://help.salesforce.com/articleView?id=relationships_considerations.htm&type=0)

Thanks,
Arvind Kumar
 
Bob MoalliBob Moalli
Could someone tell me how/where I could find out how many Master - Detail relationshps we have used?   Thanks