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
lakshmi peramlakshmi peram 

what is relation ship b/w accounts contacts and opportunities

Best Answer chosen by lakshmi peram
Medhya MahajanMedhya Mahajan
Hi Lakshmi,

 Account - Contact  and  Account - Opportunity have a Special Lookup relationship.

Simply putting, Account is a parent of both Contact and Opportunity. 

Here lookup relationship is treated as Master-Details relationship. If we delete Account record, that related contact and Opportunity records are deleted automatically from the database. 
 
 But here lookup relationship field is not mandatory field like master details relationship field. ( i.e. the relationship is Lookup on UI and master detail at the backend).
 
This link might help :
http://www.sfdcgurukul.com/2015/07/the-relationship-between-account.html

Mark as solved if this helps.

Regards
Medhya Mahajan

All Answers

Medhya MahajanMedhya Mahajan
Hi Lakshmi,

 Account - Contact  and  Account - Opportunity have a Special Lookup relationship.

Simply putting, Account is a parent of both Contact and Opportunity. 

Here lookup relationship is treated as Master-Details relationship. If we delete Account record, that related contact and Opportunity records are deleted automatically from the database. 
 
 But here lookup relationship field is not mandatory field like master details relationship field. ( i.e. the relationship is Lookup on UI and master detail at the backend).
 
This link might help :
http://www.sfdcgurukul.com/2015/07/the-relationship-between-account.html

Mark as solved if this helps.

Regards
Medhya Mahajan
This was selected as the best answer
smriti kumari 10smriti kumari 10
Hi @lakshmi peram,

Account and contact behaves as master detail in business logics but on UI it is a lookup relationship. Let me explain you a bit more for better clarity.
They are a unique category of fields commonly referred to as standard lookup fields. Unlike custom lookup fields, they have the generally have the "cascade deletion" property set to true, and unlike custom master-detail fields, they may have the "always required" property set to false. Also, these fields can restrict deletion of accounts when certain conditions are met. To learn their special properties, refer to Help for any particular field.
You can create a contact without filling account .It shows that there is a lookup relationship between account and contact.
However, if you have created a contact with account and you delete that account then respective contacts will be deleted too, this shows that it is in Master-Detail relationship. This is the actual standard behavior.
So we can say it in both ways, but it documentation it is a lookup relationship.
For more reference you can visit : http://success.salesforce.com/ideaView?c=09a30000000D9y3&id=08730000000JL3KAAW

Mark this as solved if it answers your questions to help others.

Thanks,
Smriti