-
Explain Junction relationship (Many to Many ) in detail in salesforce.
Explain Junction relationship (Many to Many ) in detail in salesforce.
-
2 Replies
-
Hi Laveena,
Salesforce supports 2 kinds of relationships like Master Detail and Lookup. They are both one-to-many relationship, and they are both defined from the many-to-one side, that is from a child to a parent. They can be made one-to-one relationship by adding validation rules, or maybe triggers to enforce the one-to-one nature, i.e. only one child is allowed.
Junction objects are used to create many to many relationships between objects. If you take the Recruiting application example, you can see that a Position can be linked to many Candidates, and a Candidate can apply for different Positions. To create this data model you need a third object "Job Application" that links the 2.
So you'd create a lookup field for both Position and Candidate object on the "Job Application" object. This will establish many to many relationships between Position and Candidate via the "Job Application" object known as the junction object.
-
You can use master-detail relationships to model many-to-many relationships between any two objects. A many-to-many relationship allows each record of one object to be linked to multiple records from another object and vice versa. For example, you create a custom object called “Bug” that relates to the standard case object such that a bug could be related to multiple cases and a case could also be related to multiple bugs. When modeling a many-to-many relationship, you use a junction object to connect the two objects you want to relate to each other.
Junction Object
A custom object with two master-detail relationships. Using a custom junction object, you can model a “many-to-many” relationship between two objects. For example, you create a custom object called “Bug” that relates to the standard case object such that a bug could be related to multiple cases and a case could also be related to multiple bugs.
Log In to reply.
Popular Salesforce Blogs
Success Stories – How DemandBlue Helped Its Clients Improve Revenue Recognition with Salesforce Revenue Cloud Implementation
Businesses that deal with subscription-based contracts, usage-based billing or other complex contracts face several difficulties in managing their billing cycle. Though Salesforce CPQ implementation does the heavy-lifting…
7 Salesforce CRM Integration Methods You Must Know About
Salesforce users require seamless data exchange from external sources to make fast and insightful business decisions. This requires merging data and functionality of Salesforce with…
Visualforce in Lightning Experience | Salesforce Guide
Although Lightning Experience introduces a whole new user interface to your Salesforce organisation, your Visualforce apps will continue to function. Many Visualforce pages operate in…
Popular Salesforce Videos
Sankey Diagram in Salesforce
A Sankey diagram is a visualization used to depict a flow from one set of values to another. The things being connected are called nodes…
Forecast Accurately With Collaborative Forecasts in Salesforce Lightning Experience
Learn how to use Collaborative Forecasts to predict your team’s sales and take advantage of cumulative rollups, forecast adjustments, territory forecasts, forecast sharing, and quota…
TrailheaDX 2020 - How Salesforce Plans To Make Virtual TDX2020 Better
For Salesforce, taking TrailheaDX digital is about more than just keeping the event going, the company wants to make TDX a better, more inclusive, and…
