function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Belinda BurgerBelinda Burger 

Primary and Secondary Master Detail Relationships

What happens to the secondary master detail relationship if the primary master detail relationship is changed to lookup?
Best Answer chosen by Belinda Burger
GauravGargGauravGarg
Hi belinda,

As far I can understand your question:
1. We have 3 Objects
     a. Object A, Object B and Object C.
     b. Object C is child object to both A, B objects in master-detail relationship. I.e. Object C is a Junction  object

Now as per your question, if you one relationship (master-detail) then what are the circumstances. Let convert Object A from master-detail to Lookup to Object C. Below are the changes which will occur:
  • If we delete Object A, 
    • Object C will not delete (no case cade deletion). 
  • If we create Object C record. 
    • Object A is not mandatory untill we mark it as mandatory, while Object B is. 
  • Object C is not an Junction object now, and will be treated as object B's child objects. 


Hope this helps!!!

Thanks,

Gaurav
Skype: gaurav62990

All Answers

GauravGargGauravGarg
Hi belinda,

As far I can understand your question:
1. We have 3 Objects
     a. Object A, Object B and Object C.
     b. Object C is child object to both A, B objects in master-detail relationship. I.e. Object C is a Junction  object

Now as per your question, if you one relationship (master-detail) then what are the circumstances. Let convert Object A from master-detail to Lookup to Object C. Below are the changes which will occur:
  • If we delete Object A, 
    • Object C will not delete (no case cade deletion). 
  • If we create Object C record. 
    • Object A is not mandatory untill we mark it as mandatory, while Object B is. 
  • Object C is not an Junction object now, and will be treated as object B's child objects. 


Hope this helps!!!

Thanks,

Gaurav
Skype: gaurav62990

This was selected as the best answer
Belinda BurgerBelinda Burger
Hi Gaurav,
This really helps. Thanks!
Cheers,
Belinda
GauravGargGauravGarg

Belinda, 

your welcome !!!

Thanks,

Gaurav