{"id":2473,"date":"2011-10-20T14:25:23","date_gmt":"2011-10-20T08:55:23","guid":{"rendered":"http:\/\/JitendraZaa.com\/blog\/?p=2473"},"modified":"2011-10-20T14:25:23","modified_gmt":"2011-10-20T08:55:23","slug":"deep-drive-in-junction-object-create-many-to-many-relationship-in-salesforce","status":"publish","type":"post","link":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/deep-drive-in-junction-object-create-many-to-many-relationship-in-salesforce\/","title":{"rendered":"Deep dive into Junction object – Create many to many relationship in Salesforce"},"content":{"rendered":"

In Interview for the salesforce technology, one common question asked is how to implement the many to many relationship. If we answer that using junction object<\/strong> then there next question comes how ? explain it and after that, next question will be what happen if i delete one master record ?<\/p>\n

So, in this article i will first show you that how to create custom objects, how to relate them and what will happen if we delete master or child?<\/p>\n

here i am going to assume that we want to relate A <\/strong>and B. <\/strong>Let us assume that we have two custom object – A<\/strong> and B<\/strong>.<\/p>\n

To provide the many to many relationship between A and B, we will need to create one more object let’s say it would be C<\/strong>, it will be called as junction object<\/strong>.<\/p>\n

So, start with creating Object A.<\/p>\n

\"Creating<\/a>
Creating Custom object in salesforce<\/figcaption><\/figure>\n

In same way, as shown in above image create B and C. For the simplicity of the example i have not added any field in Object A and B. By default Name field is provided by the salesforce on all objects.<\/p>\n

We are going to use the object C as a junction object <\/strong>for A and B.<\/p>\n

on object C, create “first Master-Detail” field and select object A as parent. This will be Primary Master – Detail relationship.<\/strong><\/p>\n

\"Salesforce<\/a>
Salesforce Master-Detail relationship - select Master object<\/figcaption><\/figure>\n

In next screen give the name of the field.<\/p>\n

\"Salesforce<\/a>
Salesforce Master-Detail relationship - Give the field Name<\/figcaption><\/figure>\n

for the Master record A, i have used name “ChildOfA” and in same way for the Master record B – i used “ChildOfB”.<\/p>\n

Untill now, we have created two fields on object C in which one refer to master record A and other will refer master record B as shown in below screen. Now we can create a tab for all the custom objects to add the record. First create record for A <\/strong>then B <\/strong>and for record C <\/strong>screen will look like below snap.<\/p>\n

\"Salesforce<\/a>
Salesforce Master-Detail relationship - Many to Many Relationship<\/figcaption><\/figure>\n

Few important points (Interview Questions of salesforce ):<\/strong><\/p>\n

    \n
  1. One Object can have only two Master-Detail relationships<\/strong>.<\/li>\n
  2. If we delete record A<\/strong> (First Master detail relationship is always primary) \u00a0\u2013 then child record c will be deleted.<\/li>\n
  3. If we delete record B<\/strong> then in this case also child record C will be deleted.<\/li>\n
  4. If we delete record c<\/strong> then only C will be deleted , master record will not be deleted.<\/li>\n
  5. If child C has two Master record A and B, Where A is primary relation then Child record C will inherit the look and feel of Parent object A.<\/strong><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    Article to show step by step process of creating junction object for Many to Many relationship in salesforce and impact of deleting one master record on others<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"jz_research_post":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[9],"tags":[331],"class_list":["post-2473","post","type-post","status-publish","format-standard","hentry","category-salesforce","tag-salesforce"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":1032,"url":"https:\/\/www.jitendrazaa.com\/blog\/others\/tips\/difference-in-master-detail-relationship-and-look-up-relationship-salesforce-interview-question\/","url_meta":{"origin":2473,"position":0},"title":"Difference in Master-Detail relationship and look up relationship – Salesforce Interview question","author":"Jitendra","date":"September 11, 2010","format":false,"excerpt":"Difference in Master-Detail relationship and look up relationship - Salesforce Interview question","rel":"","context":"In "Tech Tips"","block_context":{"text":"Tech Tips","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/others\/tips\/"},"img":{"alt_text":"Master detail and look up relationship Salesforce","src":"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/09\/Master-detail-and-look-up-relationship-Salesforce.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1038,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/salesforce-interview-questions-part-2\/","url_meta":{"origin":2473,"position":1},"title":"Salesforce Interview Questions \u2013 Part 2","author":"Jitendra","date":"September 11, 2010","format":false,"excerpt":"Interview questions of salesforce.com, interview questions of visualforce.com and APEX","rel":"","context":"In "Salesforce"","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"Account Child relationship in salesforce","src":"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/09\/Account-Child-relationship-in-salesforce.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":2825,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/salesforce-interview-questions-part-7\/","url_meta":{"origin":2473,"position":2},"title":"Salesforce Interview Questions – Part 7","author":"Jitendra","date":"April 23, 2012","format":false,"excerpt":"Basic concepts and Interview Questions of salesforce, Visualforce, Apex and SOQL","rel":"","context":"In "Apex"","block_context":{"text":"Apex","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/apex\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1253,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/where-are-the-reports-for-my-custom-object-with-related-objects-in-salesforce\/","url_meta":{"origin":2473,"position":3},"title":"Where are the reports for my custom object with related objects in salesforce?","author":"Jitendra","date":"May 22, 2011","format":false,"excerpt":"Where are the reports for my custom object with related objects in salesforce?","rel":"","context":"In "Salesforce"","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"Report of custom object with related object in Salesforce","src":"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2011\/05\/Report-of-custom-object-with-related-object-in-Salesforce.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1192,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/step-by-step-salesforce-tutorial-creating-custom-object-1-of-n\/","url_meta":{"origin":2473,"position":4},"title":"Step by Step Salesforce Tutorial \u2013 Creating custom object \u2013 1 of 6","author":"Jitendra","date":"October 6, 2010","format":false,"excerpt":"Step by Step Salesforce Tutorial - Creating custom object - 1 of n tutorial series","rel":"","context":"In "Salesforce"","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"Create Custom object Eclipse Salesforce","src":"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/10\/Create-Custom-object-Eclipse-Salesforce-300x290.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1210,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/roll-up-summary-fields-in-salesforce\/","url_meta":{"origin":2473,"position":5},"title":"Roll up Summary fields in Salesforce","author":"Jitendra","date":"October 11, 2010","format":false,"excerpt":"What is Roll up summary field in salesforce, what are the types of roll up summary field and how does it works","rel":"","context":"In "Salesforce"","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"Salesforce Rollup Summary field","src":"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/10\/Salesforce-Rollup-Summary.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/2473","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/comments?post=2473"}],"version-history":[{"count":0,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/2473\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/media?parent=2473"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/categories?post=2473"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/tags?post=2473"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}