| Lookup Relationship |
Master Detail Relation ship |
| Loosely coupled |
Tightly coupled |
| Max number of lookup is 25 |
Max number of master is 2 |
| Parent is not a mandatory field |
Parent is a mandatory field |
| Partent delete child cannot delete |
parent delete child also delete |
| Roll up cannot be made on lookup |
Roll up can be made on master-detail |
| You can have a detail record without a lookup reference |
You cannot have a detail record without a master |
| You can set profile object permissions for a child record |
You cannot set profile object permissions for a child record |
|
|
