{"id":1994,"date":"2015-09-04T15:53:35","date_gmt":"2015-09-04T19:53:35","guid":{"rendered":"https:\/\/cloudsntricks.wordpress.com\/?p=93"},"modified":"2015-09-04T15:53:35","modified_gmt":"2015-09-04T19:53:35","slug":"lookup-vs-master-detail-the-real-difference","status":"publish","type":"post","link":"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/","title":{"rendered":"Lookup Vs. Master-Detail: The Real Difference"},"content":{"rendered":"<p>I have a confession:<\/p>\n<p>For a long time, I never really understood the difference between a &#8220;<strong><span style=\"color:#00ff00;\">Lookup<\/span><\/strong>&#8221; field and\u00a0the &#8220;<span style=\"color:#00ccff;\"><strong>Master-Detail<\/strong><\/span>&#8221; lookup field.\u00a0Whenever I needed to create a field that referenced another object, I would read over the Salesforce explanation and then randomly chose one field.<\/p>\n<figure id=\"attachment_94\" aria-describedby=\"caption-attachment-94\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2015\/08\/2015-08-30_2135.png\"><img decoding=\"async\" class=\"size-medium wp-image-94\" src=\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2015\/08\/2015-08-30_2135.png?w=300\" alt=\"Lookup...or...Master-Detail\" width=\"300\" height=\"42\" \/><\/a><figcaption id=\"caption-attachment-94\" class=\"wp-caption-text\">Lookup&#8230;or&#8230;Master-Detail<\/figcaption><\/figure>\n<p>Over time I discovered various nuances, but the real &#8220;Aha!&#8221; moment was when I really, really got it.<\/p>\n<p>Simply put, a <strong><span style=\"color:#00ff00;\">Lookup<\/span><\/strong> field connects 2 objects to each other.\u00a0For example, a customer can be linked to a store they frequently shop at. This relationship, while helpful to know, does not intricately bind the customer and store to each other. If the store closes down, the customer will still be around and shopping &#8211; but in another store. The relationship ends with no affect on either end.<\/p>\n<p>Let&#8217;s use a Parent-Child analogy\u00a0to explain the\u00a0<strong><span style=\"color:#00ccff;\">Master-Detail<\/span><\/strong> relationship:<\/p>\n<figure id=\"attachment_100\" aria-describedby=\"caption-attachment-100\" style=\"width: 186px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2015\/09\/images.png\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-100\" src=\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2015\/09\/images.png\" alt=\"Parent &amp; Child\" width=\"186\" height=\"270\" \/><\/a><figcaption id=\"caption-attachment-100\" class=\"wp-caption-text\">Parent &amp; Child Relationship<\/figcaption><\/figure>\n<p><strong><span style=\"color:#ff00ff;\">Master<\/span>&#8211;<span style=\"color:#3366ff;\">Detail<\/span><\/strong> is like a human <strong><span style=\"color:#ff00ff;\">parent<\/span> <span style=\"color:#3366ff;\">child<\/span><\/strong> relationship. Just like a <strong><span style=\"color:#3366ff;\">child<\/span><\/strong> can not exist without a <span style=\"color:#ff00ff;\"><strong>parent<\/strong><\/span>, a <strong><span style=\"color:#3366ff;\">Detail<\/span><\/strong> (<strong><span style=\"color:#3366ff;\">child<\/span><\/strong>) record MUST have a <strong><span style=\"color:#ff00ff;\">Master<\/span> <\/strong>(<span style=\"color:#ff00ff;\"><strong>parent<\/strong><\/span>) record. This strong relationship makes the relationship field required on all records. As well, the <span style=\"color:#3366ff;\"><strong>child<\/strong><\/span> record inherits the same ownership and security (think DNA) as the <strong><span style=\"color:#ff00ff;\">parent<\/span><\/strong> record. Should the <strong><span style=\"color:#ff00ff;\">Master<\/span><\/strong> record be deleted, all the <strong><span style=\"color:#3366ff;\">Detail<\/span><\/strong> records will be deleted with it (think of going back in a time machine &#8211; before the <strong><span style=\"color:#ff00ff;\">parent<\/span><\/strong> was born = no <strong><span style=\"color:#ff00ff;\">parent<\/span><\/strong>, no <strong><span style=\"color:#3366ff;\">children<\/span><\/strong>).<\/p>\n<p>Similarly, going back to our store, the <strong><span style=\"color:#3366ff;\">inventory<\/span><\/strong> can have a <strong><span style=\"color:#ff00ff;\">Master<\/span><\/strong>&#8211;<strong><span style=\"color:#3366ff;\">Detail<\/span><\/strong> relationship to the store. If the <strong><span style=\"color:#ff00ff;\">store<\/span><\/strong> closes down, the <strong>inventory<\/strong> has no use and and can be deleted. You might chose to send the <span style=\"color:#3366ff;\"><strong>merchandise<\/strong><\/span> to another store which would be called Reparenting in Salesforce (sorry, not detailing that here!).<\/p>\n<p>Hope this helps you navigate object relationships in Salesforce!<\/p>\n<p>Wishing you a wonderful, relaxing, long weekend,<br \/>\nRachel<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I have a confession: For a long time, I never really understood the difference between a &#8220;Lookup&#8221; field and\u00a0the &#8220;Master-Detail&#8221; lookup field.\u00a0Whenever I needed to create a field that referenced another object, I would read over the Salesforce explanation and then randomly chose one field. Over time I discovered various nuances, but the real &#8220;Aha!&#8221; [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Lookup Vs. Master-Detail: The Real Difference - cloudraysolutions.com<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Lookup Vs. Master-Detail: The Real Difference - cloudraysolutions.com\" \/>\n<meta property=\"og:description\" content=\"I have a confession: For a long time, I never really understood the difference between a &#8220;Lookup&#8221; field and\u00a0the &#8220;Master-Detail&#8221; lookup field.\u00a0Whenever I needed to create a field that referenced another object, I would read over the Salesforce explanation and then randomly chose one field. Over time I discovered various nuances, but the real &#8220;Aha!&#8221; [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/\" \/>\n<meta property=\"og:site_name\" content=\"cloudraysolutions.com\" \/>\n<meta property=\"article:published_time\" content=\"2015-09-04T19:53:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2015\/08\/2015-08-30_2135.png?w=300\" \/>\n<meta name=\"author\" content=\"Rachel Natik\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rachel Natik\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/\"},\"author\":{\"name\":\"Rachel Natik\",\"@id\":\"https:\/\/cloudraysolutions.com\/#\/schema\/person\/3f7af52e917e04584cc84c589cf54b0e\"},\"headline\":\"Lookup Vs. Master-Detail: The Real Difference\",\"datePublished\":\"2015-09-04T19:53:35+00:00\",\"dateModified\":\"2015-09-04T19:53:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/\"},\"wordCount\":331,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/cloudraysolutions.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2015\/08\/2015-08-30_2135.png?w=300\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/\",\"url\":\"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/\",\"name\":\"Lookup Vs. Master-Detail: The Real Difference - cloudraysolutions.com\",\"isPartOf\":{\"@id\":\"https:\/\/cloudraysolutions.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2015\/08\/2015-08-30_2135.png?w=300\",\"datePublished\":\"2015-09-04T19:53:35+00:00\",\"dateModified\":\"2015-09-04T19:53:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/#primaryimage\",\"url\":\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2015\/08\/2015-08-30_2135.png\",\"contentUrl\":\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2015\/08\/2015-08-30_2135.png\",\"width\":1090,\"height\":152,\"caption\":\"Lookup...or...Master-Detail\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/cloudraysolutions.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Lookup Vs. Master-Detail: The Real Difference\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/cloudraysolutions.com\/#website\",\"url\":\"https:\/\/cloudraysolutions.com\/\",\"name\":\"cloudraysolutions.com\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/cloudraysolutions.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/cloudraysolutions.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/cloudraysolutions.com\/#organization\",\"name\":\"cloudraysolutions.com\",\"url\":\"https:\/\/cloudraysolutions.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cloudraysolutions.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2023\/01\/cloudray-solutions-logo.png\",\"contentUrl\":\"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2023\/01\/cloudray-solutions-logo.png\",\"width\":346,\"height\":147,\"caption\":\"cloudraysolutions.com\"},\"image\":{\"@id\":\"https:\/\/cloudraysolutions.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/cloudraysolutions.com\/#\/schema\/person\/3f7af52e917e04584cc84c589cf54b0e\",\"name\":\"Rachel Natik\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cloudraysolutions.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a557df15a34a0b827f7c6e94df4687d0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a557df15a34a0b827f7c6e94df4687d0?s=96&d=mm&r=g\",\"caption\":\"Rachel Natik\"},\"sameAs\":[\"http:\/\/cloudraysolutions.com\"],\"url\":\"https:\/\/cloudraysolutions.com\/author\/rachel\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Lookup Vs. Master-Detail: The Real Difference - cloudraysolutions.com","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/","og_locale":"en_US","og_type":"article","og_title":"Lookup Vs. Master-Detail: The Real Difference - cloudraysolutions.com","og_description":"I have a confession: For a long time, I never really understood the difference between a &#8220;Lookup&#8221; field and\u00a0the &#8220;Master-Detail&#8221; lookup field.\u00a0Whenever I needed to create a field that referenced another object, I would read over the Salesforce explanation and then randomly chose one field. Over time I discovered various nuances, but the real &#8220;Aha!&#8221; [&hellip;]","og_url":"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/","og_site_name":"cloudraysolutions.com","article_published_time":"2015-09-04T19:53:35+00:00","og_image":[{"url":"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2015\/08\/2015-08-30_2135.png?w=300"}],"author":"Rachel Natik","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Rachel Natik","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/#article","isPartOf":{"@id":"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/"},"author":{"name":"Rachel Natik","@id":"https:\/\/cloudraysolutions.com\/#\/schema\/person\/3f7af52e917e04584cc84c589cf54b0e"},"headline":"Lookup Vs. Master-Detail: The Real Difference","datePublished":"2015-09-04T19:53:35+00:00","dateModified":"2015-09-04T19:53:35+00:00","mainEntityOfPage":{"@id":"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/"},"wordCount":331,"commentCount":1,"publisher":{"@id":"https:\/\/cloudraysolutions.com\/#organization"},"image":{"@id":"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/#primaryimage"},"thumbnailUrl":"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2015\/08\/2015-08-30_2135.png?w=300","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/","url":"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/","name":"Lookup Vs. Master-Detail: The Real Difference - cloudraysolutions.com","isPartOf":{"@id":"https:\/\/cloudraysolutions.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/#primaryimage"},"image":{"@id":"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/#primaryimage"},"thumbnailUrl":"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2015\/08\/2015-08-30_2135.png?w=300","datePublished":"2015-09-04T19:53:35+00:00","dateModified":"2015-09-04T19:53:35+00:00","breadcrumb":{"@id":"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/#primaryimage","url":"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2015\/08\/2015-08-30_2135.png","contentUrl":"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2015\/08\/2015-08-30_2135.png","width":1090,"height":152,"caption":"Lookup...or...Master-Detail"},{"@type":"BreadcrumbList","@id":"https:\/\/cloudraysolutions.com\/lookup-vs-master-detail-the-real-difference\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cloudraysolutions.com\/"},{"@type":"ListItem","position":2,"name":"Lookup Vs. Master-Detail: The Real Difference"}]},{"@type":"WebSite","@id":"https:\/\/cloudraysolutions.com\/#website","url":"https:\/\/cloudraysolutions.com\/","name":"cloudraysolutions.com","description":"","publisher":{"@id":"https:\/\/cloudraysolutions.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cloudraysolutions.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/cloudraysolutions.com\/#organization","name":"cloudraysolutions.com","url":"https:\/\/cloudraysolutions.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cloudraysolutions.com\/#\/schema\/logo\/image\/","url":"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2023\/01\/cloudray-solutions-logo.png","contentUrl":"https:\/\/cloudraysolutions.com\/wp-content\/uploads\/2023\/01\/cloudray-solutions-logo.png","width":346,"height":147,"caption":"cloudraysolutions.com"},"image":{"@id":"https:\/\/cloudraysolutions.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/cloudraysolutions.com\/#\/schema\/person\/3f7af52e917e04584cc84c589cf54b0e","name":"Rachel Natik","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cloudraysolutions.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a557df15a34a0b827f7c6e94df4687d0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a557df15a34a0b827f7c6e94df4687d0?s=96&d=mm&r=g","caption":"Rachel Natik"},"sameAs":["http:\/\/cloudraysolutions.com"],"url":"https:\/\/cloudraysolutions.com\/author\/rachel\/"}]}},"_links":{"self":[{"href":"https:\/\/cloudraysolutions.com\/wp-json\/wp\/v2\/posts\/1994"}],"collection":[{"href":"https:\/\/cloudraysolutions.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cloudraysolutions.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cloudraysolutions.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/cloudraysolutions.com\/wp-json\/wp\/v2\/comments?post=1994"}],"version-history":[{"count":0,"href":"https:\/\/cloudraysolutions.com\/wp-json\/wp\/v2\/posts\/1994\/revisions"}],"wp:attachment":[{"href":"https:\/\/cloudraysolutions.com\/wp-json\/wp\/v2\/media?parent=1994"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cloudraysolutions.com\/wp-json\/wp\/v2\/categories?post=1994"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cloudraysolutions.com\/wp-json\/wp\/v2\/tags?post=1994"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}