-
What is the difference between Lookup and Master Detail relationship in Salesforce ?
I also wanted to know, how they are converted to each other form like lookup to master detail?
-
1 Reply
-
Master-Detail Relationship :
- It creates the parent(master) child(Detail) relationship between objects.
- If we delete master records then detail (Child) records are deleted.
- Rollup-summary field can be created in a master-detail relationship.
- We can have maximum 2 master details on an object
- Master is required field on the child object.
Look up Relationship :
- Look up relationship creates relations between two objects.
- If we delete any object then another object is not deleted.
- We can have maximum 25 lookups on an object.
- Parent is not required in the child record.
- Rollup-summary field can be created in this relationship.
To convert master-detail to lookup and vice versa -
You can convert a master-detail relationship to a lookup relationship as long as no roll-up summary fields exist on the master object.
You can convert a lookup relationship to a master-detail relationship, but only if the lookup field in all records contains a value.
-
This reply was modified 8 years, 9 months ago by
Ajay Prakash.
Log In to reply.
Popular Salesforce Blogs
How an HMS Simplifies Hospital Inventory and Supply Chain Management
Introduction A hospital management system (HMS) plays a crucial role in streamlining hospital operations by automating processes, reducing manual tasks, and improving efficiency. From clinic management and…
Email Service-Inserting Data in Salesforce using Email Attachment
Force.com provides us powerful and secure functionality for sending and receiving emails. We can execute our apex logic whenever we receive an email. By using…
CPQ and CRM: The Best of both Worlds to Empower your Sales Teams
How efficient are your sales processes? While there may not be a definitive answer to this question, it makes us rethink our sales processes and…
Popular Salesforce Videos
Salesforce Einstein Search
Salesforce Einstein Search makes your users more productive by bringing the power of Einstein and AI to Salesforce Search. Einstein Search is Personal, Natural, and…
How Cyntexa Helped Diet Meal And Food Ordering Service Providers Offer Their Users The Ability To Order Online | Salesforce Commerce Cloud
It is important to keep your business at the top with the latest technical advancements. Presenting you a case study showcasing how Cyntexa Helped Diet…
What are Global Picklists and Field Dependency in Salesforce? | How to Create Global Picklists?
In this video, Shrey is not only teaching but also demonstrating to you "What are Global Picklists & Field Dependency in Salesforce?". You will be…
