How many child relations can i have in objectin salesforce


As a best practice, don’t exceed 10,000 child records for a master-detail relationship. Each custom object can have up to two master-detail relationships and up to 40 total relationships.


What are Salesforce object relationships?

Here the custom field of an Object record contains a link in another object record. To build many custom object in, relationships plays a major role. In, Relationships are used to fetch data from other object records. Here the parent ID is stored in pre-defined relationship. Types of Salesforce Object Relationships.

What is a many to many relationship in Salesforce?

A parent object can have many child’s objects but a child object must have only one parent object. Lookup Relationship. Many to Many (M:M). Master-Detail Relationship in Salesforce. Master-Detail relationship is a one type of relationship which form tight bond relationship between Parent object and Child object.

Can a child record be associated to a parent in Salesforce?

In lookup Child record need not be associated to a parent. No Cascade record deletion happens. Lookup field is not required on the page layouts of the detail object. No Rollup summary fields can be created in Lookup relationship. Doe’s not inherit any settings from it’s parent record. Many to Many Relationship in Salesforce.

Is your Salesforce Org related to your family?

If your Salesforce org was the family, then the objects would be related but not in the same family. A great example of such is relating payment records to an account from an ERP system – the ERP system is external to Salesforce but the records are important.


How many relationship fields can be created in an object?

Each custom object can have up to two master-detail relationships and many lookup relationships. Each relationship is included in the maximum number of custom fields allowed….Required Editions.If the child entity has these permissionsThese permissions are enabled on the parent entityView All OR ReadRead1 more row

How many Lookup Relationships fields can be created per child?

Lookup field characteristics: Custom objects allow up to 40 custom lookup fields (Salesforce can increase the limit to 50): Since we are allowed to create so many of these they are ‘everywhere’.

What is the limit of master detail relationships per object?

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

Can a child object be a parent of another object in Salesforce?

A child of one master detail relationship can’t become a parent of another object. To relate an object to another object, no records should exist in the child object. Rollup summary fields can only be created on Master records, which are used to calculate the sum, avg, min etc.

How many relationships can you have in Salesforce?

Each custom object can have up to two master-detail relationships and up to 40 total relationships. The Related To entry can’t be changed after you save the relationship. A profile or a permission set can have an entity, such as Account, with a master-detail relationship.

What is the maximum number of lookup relationships that can be added on an object in Salesforce?

Maximum number of Lookup realtionships on a Standard Object is :25.

What is the limit of look up relationships per object?

By default, the system is limited to 40 lookup fields per object, up to two of which may be master-detail relationships if it is a custom object. You can request more than the 40 relationship per object limit if absolutely necessary, although there are performance implications for doing so.

How many lookups can be created in an object?

You can have a maximum of 40 lookups on an object. You can have a maximum of two master details on an object.

What happen if child have two master records and one is deleted?

If child have two master records and one is deleted then the record is deleted and placed in the recycle bin.

What are the three types of object relationships?

An object relationship in Salesforce is a two-way association between two objects. Relationships are created by creating custom relationship fields on an object….Salesforce Object RelationshipsMaster-detail.Lookup.Hierarchical.

Is junction an object parent or child?

Junction Object is a type of custom object which allows linking one custom object or one custom instance to many children records and each child can equally be linked to many parents.

Can a child record be a master to some other object?

Administrators can, however, allow child records in master-detail relationships on custom objects to be reparented to different parent records by selecting the Allow reparenting option in the master-detail relationship definition. You can have up to three custom detail levels.

Lookup Relationships

A Lookup is a loosely coupled relationship, allowing you to connect one object to another in a one-to-many fashion. In this example, you can see that an Asset may be involved with a number of cases. In this scenario, if the case is deleted, the Asset will remain and vice versa.

See more on

Master-Detail Relationship

  • A master-detail relationship is a strongly coupled relationship, meaning if the parent is deleted, so are the child records. This is a good thing and can be incredibly helpful. This relationship seems to scare people, but it shouldn’t! Master-detail also allows the parent record to control child record attributes such as sharing and visibility. Whichever security setting you chose for the parent rec…

See more on

Many-To-Many Relationships

  • Say you have a situation where it is required you have many of one record related to many of another. Duplicating that lookup field a number of times on each object is not best practice and will get very messy. This is where we should leverage Junction Objects. In the image below, we see that a session can have multiple speakers but also speakers c…

See more on

Self Relationship

  • Let’s say, for example, you have a Campaign. This campaign is part of a bigger campaign. You can use a lookup field from campaign to… campaign! Why? This would be a great situation to show how multiple child campaigns relate to the main parent campaign (known as a Campaign Hierarchy).

See more on

External Relationships

  • There are two more types of Lookups for working with external objects we should cover briefly: 1. Indirect lookup relationships: allow a relationship to be formed between a Salesforce object and an external object. If your Salesforce org was the family, then the objects would be related but not in the same family. A great example of such is relating payment records to an account from an E…

See more on

Hierarchical Relationships

  • A simple but commonly forgotten relationship in Salesforce is hierarchical. This unique relationship can only be used on the user object and is designed to create a hierarchy of users. For example, it could be used to create a lookup field for the user object, which can be used to list the user’s manager.

See more on


  • Learning the different types of relationships in Salesforce and when to use them, is a core part of any professionals job. Hopefully, this article has given you a complete overview of the relationships, and when to use them.

See more on

Leave a Comment