+ Start a Discussion
SujanSaiSujanSai 

Lookup Vs Master Detail

Hi all,
Can any one explain the difference between Lookup and Master Detail Relationship in salesforce?
Thanks,
Sujan
Best Answer chosen by SujanSai
Deepthi BDeepthi B
Hello Sujan,
Please find the following differences.
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
5. Can create a Roll up Summary Field on Master 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.
4. The child records will have the sharing/security settings of their own owner.
Hope this helps you!
Regards,
Deepthi