What is the difference between Lookup and Master Detail relationship in Salesforce ?

Master-Detail Relationship :

1. It creates the parent(master) child(Detail) relationship between objects.
2. If we delete master records then detail (Child) records are deleted.
3. Rollup-summary field can be created in a master-detail relationship.
4. We can have maximum 2 master details on an object
5. Master is required field on the child object.

Look up Relationship :

1. Look up relationship creates relations between two objects.
2. If we delete any object then another object is not deleted.
3. We can have maximum 25 lookups on an object.
4. Parent is not required in the child record.
5. 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, 4 months ago by  Ajay Prakash.