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
MandadiMandadi 

Why Master-Detail Relationship is preferable to create junction object in salesforce

Hi,

 

      Can anyone help me "Why two Master-Detail Relationship is  preferable to create junction object. Why cant with two Lookup relationships or one master-detail and one lookup relationship".

 

 

Thanks in Advance

diydiy

In Master- detail relationships , parent and child record have same owner ... so security is high and confedential

 

 

Please mark my answer as a solution if it was helpful so it is available to others as a proper solution.
If you felt I went above and beyond, please give me Kudos by clicking on the star icon.
souvik9086souvik9086

The first master-detail relationship you create on your junction object becomes the primary relationship. This affects the following for the junction object records:

  • Look and feel: The junction object's detail and edit pages use the color and any associated icon of the primary master object.
  • Record ownership: The junction object records inherit the value of the Owner field from their associated primary master record. Because objects on the detail side of a relationship do not have a visible Owner field, this is only relevant if you later delete both master-detail relationships on your junction object.
  • Division: If your organization uses divisions to segment data, the junction object records inherit their division from their associated primary master record. Similar to the record ownership, this is only relevant if you later delete both master-detail relationships.

Reference

http://help.salesforce.com/HTViewHelpDoc?id=relationships_manytomany.htm&language=en_US
Groundwire ConsultingGroundwire Consulting

Hi,

  

 A many-to-many relationship allows each record of one object to be linked to multiple records from another object .

 

For example, you may have a custom object called “Course” that relates to the student object such that a course could be related to multiple students  and a  students could also be related to multiple courses. 

 

To create a many-to-many relationship, simply create a custom junction object with two master-detail relationship fields, each linking to the objects you want to relate.

 

and if you have any more questions please feel to contact me on support@groundwireconsulting.com
Mukesh Kumar 107Mukesh Kumar 107
The actual implementation, which relationship to use, depends on the requirement. As know, you could use any of the relationship but Master-Detail relationship would cover more scenarios by default.