---
title: "Look-up VS Master-Detail Relationship in SalesForce"  
description: "Look-up VS Master-Detail Relationship in SalesForce"  
author: "Royce Roy"  
published: 2015-03-04  
updated: 2015-03-04  
canonical: https://www.mindstick.com/forum/12998/look-up-vs-master-detail-relationship-in-salesforce  
category: "sales force"  
tags: ["cloud computing", "sfdc", "dev-401"]  
reading_time: 2 minutes  

---

# Look-up VS Master-Detail Relationship in SalesForce

I am new to [Salesforce](https://www.mindstick.com/articles/126174/automating-salesforce-cpq-testing), I am very confuse about *look- up [relationship](https://yourviews.mindstick.com/view/80819/live-in-relationship-protecting-the-right-to-live-together)* and *Master- [Detail](https://www.mindstick.com/forum/157518/what-is-svm-algorithm-and-also-explain-it-in-detail) Relationship* in Salesforce. [Please tell me](https://www.mindstick.com/forum/33900/please-tell-me-what-are-the-technique-to-content-optimization) some [differences](https://www.mindstick.com/articles/12918/cat-5e-vs-cat-6a-understanding-the-major-differences) between the two relationships.

## Replies

### Reply by Anonymous User

**Master-detail relationship**\

1. 1)in MD relationship field value is mandatory\
2. 2) here parent record is deleted automatically child records is deleted\
3. 3) an object is allowed only 2 m-d relationship fields\
4. 4) if we give any rules to parent that rules automatically goes to the child. Child does not conatin any seperate rules.\
5. 5)we can directly conert m-d relationship to lookup relationship\
6. 6) if we give a value to m-d relationship field that value doesnot changed.\

\
\
\
**Lookup relationship**\

1. 1)in lookup relationship field value is not mandatory\
2. 2) here parent record is deleted automatically child records are not deleted\
3. 3) an object is allowed only 25 relationship fields\
4. 4) here parent rules and child rules are may be same or not.\
5. 5)if we cannot give a value to the lookup field then we can't directly conert lookup relationship to master-detail relationship here first we need to give a value to the lookup field.\
6. 6) if we give a value to lookup relationship field we can change that value whenever we required.\

\
hope this wil help you understand the difference between the two :)

### Reply by Samuel Fernandes

**Master – Detail Relationship :**\

1. If we delete master records then detail (Child) records are deleted.\
2. It creates the parent(master) child(Detail) relationship between objects.\
3. Child records do not have Owner fields it takes parents records owner as child records owner.\
4. We can have maximum 2 master details on an object\

**Look up relationship :**\

1. Look up relationship creates relations between two objects.\
2. If we delete any object then other object is not deleted.\
3. We can have maximum 25 lookup on an object.\


---

Original Source: https://www.mindstick.com/forum/12998/look-up-vs-master-detail-relationship-in-salesforce

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.