Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

On Opportunity there is a lookup relationship to Account.But why it behaves as Master-Detail as we can create Rollup Summary Fields on Account.

Similarly if we delete Account then Contact gets deleted but there is lookup relationship between Contact and Account

What is the relationship between Opportunity/Account and Contact/Account ? (Lookup or Master-Detail)

share|improve this question
up vote 4 down vote accepted

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.

share|improve this answer
@sfdcfox..When I click on help against AccountName field on Contact I am getting below link which doesn't give any… – sfdc Jun 15 '14 at 20:30
Why there is an option for rollup summary for opportunities but not for contacts from Account – sfdc Jun 15 '14 at 20:34
1 It's not that simple, I'm afraid. You usually need to refer to Release Notes (e.g. Spring '13 Release Notes), the Developer Documentation, and Help (e.g. Opportunity Fields), and the Idea Exchange. Many features exist because users asked for it, some because it makes good business sense, and others for no known reason at all. – sfdcfox Jun 15 '14 at 20:52
1 On the other hand, in your specific example, the "why" for being able to roll up opportunity fields but not contact fields is a matter of business purpose. Many organizations find it useful to be able to roll up opportunity stats to an account (e.g. total sales, pipeline, etc), while only a few organizations would find it useful to roll up contacts. That's not to say that you can't write your own code to perform a roll up yourself, but simply that there hasn't been sufficient interest or priority to implement the feature. – sfdcfox Jun 15 '14 at 20:54
1 The problem with "standard" fields versus "custom" fields is that standard objects have specially coded functions to optimize their use, while custom objects use a generic engine. That's why you can't (yet) create an Address field; these are special fields with special properties that are specially coded into the platform. The community (us) will be here to help you along, and you'll surely find some neat trick tucked away somewhere that'll be useful. – sfdcfox Jun 15 '14 at 20:58

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.