function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Ionut Constantin SultanaIonut Constantin Sultana 

Schema builder master detail possible bug

Hi, I'm new to salesforce administration and I'm trying to figure it out why Schema Builder doesn't show the master->detail relationship between Account and Opportunity, there are only 2 blue lines (lookup) between these 2 objects.
Can you comment on this?

User-added image

 
Best Answer chosen by Ionut Constantin Sultana
Khan AnasKhan Anas (Salesforce Developers) 
Hi Ionut,

Greetings to you!

Accounts and Opportunities have a different type of relationship that is standard to the way that salesforce has it set up. If you view your schema builder you would see that salesforce has it labeled as a Lookup Relationship. Opportunities and Accounts have a lookup relationship but this relationship has a property called CascadeDelete (https://help.salesforce.com/articleView?id=000313755&type=1&mode=1) set to true. This is why the opportunity is deleted when the parent object is deleted. 

Please refer to the below links which might help you further.

https://salesforce.stackexchange.com/questions/28624/relationship-between-account-and-contact

https://salesforce.stackexchange.com/questions/40589/relationship-between-account-and-opportunity-and-account-and-contact

I hope it helps you.

Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future. It will help to keep this community clean.

Thanks and Regards,
Khan Anas

All Answers

Khan AnasKhan Anas (Salesforce Developers) 
Hi Ionut,

Greetings to you!

Accounts and Opportunities have a different type of relationship that is standard to the way that salesforce has it set up. If you view your schema builder you would see that salesforce has it labeled as a Lookup Relationship. Opportunities and Accounts have a lookup relationship but this relationship has a property called CascadeDelete (https://help.salesforce.com/articleView?id=000313755&type=1&mode=1) set to true. This is why the opportunity is deleted when the parent object is deleted. 

Please refer to the below links which might help you further.

https://salesforce.stackexchange.com/questions/28624/relationship-between-account-and-contact

https://salesforce.stackexchange.com/questions/40589/relationship-between-account-and-opportunity-and-account-and-contact

I hope it helps you.

Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future. It will help to keep this community clean.

Thanks and Regards,
Khan Anas
This was selected as the best answer
Ionut Constantin SultanaIonut Constantin Sultana

Thank you very much Khan Anas! Your answer helped me a lot!