What is the difference between lookup and master-detail relationships in Salesforce?

Lookup relationships are more flexible. They allow objects to exist independently. Master-detail relationships create a strong link between objects. The detail object depends on the master object's existence. Lookup relationships don't affect record ownership or sharing. Master-detail relationships do. The detail record inherits security settings from its master.

How to create a master-detail relationship in Salesforce?

To create a master-detail relationship, go to the Object Manager, select the detail object, click " Fields & Relationships ," and then " New ," choose " Master-Detail Relationship ," and pick the master object. Set the field label and name. If needed, choose roll-up summary options. Set field-level security and page layout settings. Save your changes.

Can a master-detail relationship be converted to a lookup relationship in Salesforce?

Yes, you can change a master-detail relationship to a lookup. In the Object Manager, open the relationship field, click "Edit," and change the relationship type to "Lookup." This change can affect data access and roll-up summaries. Make sure to review and adjust sharing rules after conversion.

What are the limitations on the number of master-detail relationships in Salesforce?

Up to two master-detail relationships can exist between objects, and custom objects can be on the detail side of up to two master-detail relationships. Standard objects can't appear on the detail side of a master-detail relationship with custom objects. The number of lookup relationships is unlimited.

When should a master-detail relationship be used instead of a lookup relationship in Salesforce?

Use master detail when objects are closely linked. It's good for parent-child relationships where the child can't exist alone. Examples include orders and order items or accounts and contacts. Master detail is useful for rollup summaries and cascading deletions. It's ideal when you want automatic sharing and ownership inheritance.

What key characteristics differentiate a lookup relationship from a master-detail relationship in Salesforce?

Lookup relationships are more independent. Records can exist independently and have separate owners. They don't allow roll-up summaries or affect sharing rules. Master detail creates a strong bond. Detailed records can't exist without a master. They share the master's access settings. Master-detail enables rollup summaries and cascading deletions.

Skip to content

Tutorials
Agentforce
Training
Free
Store
Consulting
Join Workshop

Master-Detail vs Lookup Relationships in Salesforce (Complete Guide with Examples)

April 1, 2026 by Shubham

In Salesforce, data is stored in objects like Account, Contact, Opportunity, and custom objects. But in real business scenarios, data is never isolated. Different objects need to be connected with each other.

F