How to implement many to many relationship in Salesforce | Junction Object in Salesforce
Вставка
- Опубліковано 27 лип 2024
- In this video, Shrey has explained the following things :
- Why there is a need to create many to many relationship in Salesforce?
- What is junction object in Salesforce?
- How junction object helps in creating a many to many relationship?
- Points to consider while creating junction object.
This is part 3 of the relationship videos, find the link to other parts below.
Understanding Relationships in Salesforce (Basic) | How relationship works in Salesforce
• Understanding Relation...
What is Master Detail & Lookup relationship in Salesforce? | Different Types of Relationship Fields
• What is Master Detail ...
Grow your business with THE BEST SALESFORCE IMPLEMENTATION and CONSULTANCY SERVICES
Reach us out here: cyntexa.com
------
Get the BEST SALESFORCE COURSES & TRAINING here s2-labs.com/
------
STALK ME ON:
Instagram: / imshreyshar...
Facebook: / salesforcehu...
Twitter: / iamshreysharma
LinkedIn: / imshreysh...
------
Shrey is a Chief Executive Officer at Cyntexa which is considered as one of the top Salesforce Consulting Partner in USA, UK, UAE, Australia, Singapore & India having a vibrant team of 100+ certified Salesforce experts which include developers, architects, consultants, administrators, and MVPs.
Shrey took Cyntexa from 5 to 100+ people in less than 1.5 years while multiplying the revenues by 8 times. Shrey has been an entrepreneur since the age of 13 as he was buying and selling stuff and making money in the school itself. Shrey is the Youngest Salesforce MVP in the world who firmly believes in providing value to the people and building long term value-based relationships. His mission is to disrupt the way professional technical services are delivered by bringing back the empathy for the end-user rather than being operational and transactional.
Shrey is popularly known as Salesforce Hulk in the Salesforce ecosystem as he was the first one to start creating videos on Salesforce on his UA-cam channel named as Salesforce Hulk and that too at the age of 19. Shrey is also the founder of S2 Labs which is a Salesforce Training Company, being the 1st one to start Salesforce training in Rajasthan, India, and currently selling his courses worldwide. Shrey is also a marvelous speaker who actively presents on topics that revolve around Salesforce and Entrepreneurship in various worldwide conferences. Shrey has also been a Judge in multiple technical and business hackathons organized by the Government of India like Smart India Hackathon.
Shrey is a leader with out of the box thinking who emphasizes not only on hitting the sales targets but also on providing an amazing experience to the customers as well as employees. Shrey believes in building a team with strong values, ethics, and behavior which leads to the amazing culture at Cyntexa.
-------
#salesforce
#learnsalesforce
#salesforechulk
I am 41 yr from Dallas,Texas and love your explanation. I am from QA background but follow your videos a lot. I am bit slow in grasping the concepts. So, I watch each video 10 or 15 times ( sometimes even more ) just curious in seeking knowledge in Salesforce. And maybe next year I 'll be ready for some admin positions. Thank you for your service to Salesforce community.
sir,for admin fresher ,what is starting salary in Dallas?
$95 per hour, I have manipulated my resume and now consultancy guy is shadowing me.
@@saikrishnaallampally3543 hello, i am preparing for Admin, and struggling to find my first project as a fresher. if u got your first project as a fresher could u please guide me how to get. Thank you
Hi @@barneycasting8331 ,is there any changes to get onsite chances from india for salesforce developer now(2024)
@@snehalthakkar136 I directly started my career as salesforce developer..
We can Crete total of 40 relationships on an object. Limit to create MD relation is 2 for a single object. If we create 2 MD then we can create 38 lookup or else 1 MD and 39 Lookup or 0 MD and 40 lookup relationships.
Total of 40 relationship fields we can create per object. We can only create 2 M-D relationship fields per object, in that case 38 lookups can be created. If one M-D relationship field is created than 39 lookups can be created. If no master-detail relationship fields created we can create 40 lookups.
Very helpful video, this is a topic I have struggled to grasp for a while, and you made it very clear. Keep up the great content Shrey!
Great session shrey.. It was really helpful for me as I was struggling to understand the concept of junction object. You explained it really well. Thanks and keep it up..😊
Thanks for your valuable information about junction object with clarity
That was a very good explanation. Thank you very much.
Explained very well ! Thank you !
Good Job Hulk. Explained very well - I got the point.
Once again thank you so much for your support and help. You are amazing and funny
Thank you for writing it on the board. Can you also do the demo like you always do in your previous videos. It will be helpful
Superb vdo. You explained it in easy way.. Thnks!!
Great content to clear concepts! Thank you so much, Shrey Sir! One question though - you said, 'Look n Feel' is derived from Master object'. What can be understood as look and feel - page layout? :)
Awesome videos Mr. Hulk. I passed Admin 201 with zero experience and only because I watched ALL your videos in 10 days! Yayy. Thank you. I need to learn Service Cloud in detail. Will you be making any Service Cloud videos? Any advice how I can learn it in detail?
thanks for the explanation
I like the way of you teach to us 👤 thank you sooo much brother.....
Very good explanation.
Excellent💯 Explanation. Concept is clear!, Thank You.
We can create maximum of 40 relationships on objects .Maximum 2 master-detail and 38 Lookup or 0 Master 40 lookup or 1 master and 39 lookup but there cannot be more than 2 mater-detail on single object.
Hey Ankur
You won the Junior Hulk Challenge.
Please reach me out me on salesforcehulk@gmail.com to get your swag. :)
Salesforce help text says the maximum is 25 relationships. Has the maximum been reduced from 40 to 25?
@@chao.m I have the same question!
@@SalesforceHulk Salesforce help text says the maximum is 25 relationships. Has the maximum been reduced from 40 to 25?
@@SalesforceHulk can u explain why only 2 relationships can be made on master detail?
Superb useful! I would kindly ask for an explanation about how to implement a junction object referencing two records of the same object (and having only one related list)
Please upload tutorials on lighting, it will be a great help for me.
thanks for sharing
Excellent is not the word👍👍👍👍
Please create a video on Apex , visual force, lightning coding etc .. Your videos are fab
thanks..
Soooper😍🤩
very good Shrey make more video on different different concepts like this video thank you.......
master detail relationship on object is maximum 2 and lookup relationship on object is maximum of 40
your videos are awesome
Does this work only for two tables/objects or it can be used for multiple objects?
Ya , I am understand what you trying to say.☺️
total 40 relationship we can create it might be...
1) 38 lookups and 2 masterdetail or
2) 39 lookups and 1 master detail or
3) 40 lookups or 0 masterdetail relationships
I think this is the second time when you missed the Junior Hulk challenge swag?
@@SalesforceHulk I try my best. I have hope one day I'll win swag t-shirt.. :)
Appreciate the spirit man!
@@SalesforceHulk I'm big fan of yours I think without I'm nothing .. appreciate u r hardworking for us ... 👏👏👏👍👍
what was wrong on your answer?
Can u upload video on trigger ?
Given that a junction object can have at most two master-detail relationships and that a _junction_ must be between at least two objects, does it mean that if I need to establish many-many between three objects I must create three separate junction objects, one for each combination of two out of three m:m relationships?
What an explanation that was!! 👍👍
Best explanation I have ever heard building from the ground up great
very good explanation thnx very much
You are most welcome
sir....... you are the best:)
If we have to create one to one relationship without triggers and workflow rule but with lookup relationship then how it is possible??
Hey, why Salesforce allow to create two records with the same masters ID's? Aren't they composed primary key in the junction object?
so great video again Shrey
So when one of the objects is deleted what happens to the junction object.
Again when both of the objects are deleted what happens to the junction object?
Answer: 1st case - Junction object is deleted and moved to the recycle bin.
2nd case Junction object is deleted permanently
Plz upload Triggers .... concept
@salesforce hulk What is the best way to implement unique records in Junction object [e.g. S-1, G-1 combination should not be allowed to be repeated]?
Great Explanation.
Thank you
Total 40 relationships, So 38 look-up and 2 masterdetail,
Not putting this answer for the sake of T shirt but for the simplified way of explaining this concept, this one is very confusing concept (may be for me) but you made me understand this very easily, Thank u very much
Glad to know that it helped, Mahesh :)
Best video on this topic on UA-cam
Best explanation forever
Thank You, Keep Supporting
Tell me student_ group (junction) me primary key kya hoga with q hoga
Hi shrey ... recently I knew about your videos and subscribed your channel. Now I am watching and following your 2 or 3 videos everyday. In this video you have not shown how to create many to many relationships on lighting ... i mean on Saleforce app. Plz share the link if you already uploaded any video on this. If not then plz help me to understand how to create many to many relationship on two objects .
Will wait for your response.
Thanks 😊
We can create only 2 master detail relationships and 25 lookup which can be extended to maximum 40.
Can anyone please explain why we can have a total of 40 relationships associating an object.
Hi , Nicely explained. I do have a question though. I have successfully managed to implement a many to many relationship but can not add a roll up summary field on Student obj to see how many groups is he enrolled in. Can you please explain how might that be possible?
Use process Builder to do this.
Which object will hold reference to the junction primary key? In other words, How does one associate the relation from UI perspective? In other words, how will we implement on a UI?
Please make a video on Salesforce maps
40 lookup relationship fields can be created using Lookup relation and 2 using Master Details relationship
Bro what is look and filed
I am struggling to understand if this operation requires using some of the Maximum 2 master-detail, can you provide some input on that?
I have understood why JUNCTION OBJECT is needed, this video was quite helpful. Since I'm working with existing objects that are being connected what is the best way to seed current data into the JUNCTION OBJECT. I'm concluding I have to export from both Pkey objects merge and import as one?
We can creare 40 lookup realtionship and 2 master deatil realtionship
supperb
in look up relation ship created by 40 relations and master detail realation ship only 2 realations can be possible
2 M-D and 25 Lookup
Total 40 relationship in one object,38 lookup and 2 master details
2 master detail relationships and 38 look up relationships or
1 master detail relationship and 39 look up relationships or
0 master detail relationships and 40 look up relationships
ILY
Hello, please let me know Can we delete and and delete the Junction object?
Junction object records are deleted when either associated master record is deleted and placed in the Recycle Bin. If both associated master records are deleted, the junction object record is deleted permanently and can't be restored.
Can a junction object be used in a record field or only in a related list?
When modeling a many-to-many relationship, you use a junction object to connect the two objects you want to relate to each other. A custom object with two master-detail relationships. Using a custom junction object, you can model a “many-to-many” relationship between two objects.
On any Object we can have max of 2 Master - Detail Relationship and max of 40 Look-Up Relationship
2 master detail relationships and 38 lookup relationship data types
25 lookup
2 master detail
for each custom object we can create upto 25 lookup relationship and upto 2 master-detail relationship we can create.
2master detail and 38 lookup relationship
Total 40 relationship in which 2 M-D and 38 lookup relationship
👍
We can create 2 master-detail relationships and
50 look-up relationships on an object.
Thank you 😊
Very good!
Is it 50 or 40?
What if we create many to many relationships with junction objects using lookup , what will be the Sharing and security scenario then?
The junction object will have its own security & sharing settings.
@@SalesforceHulk Thanks for your quick reply, could you please share your video or web article link that will put more light in this scenario ?
40 Lookup relationships and 2 master details relationship
We can Crete a total of 40 relationships on an object.
MD relation is 2 for a single object.
2 MD then we can create 38 lookups
1 MD and 39 Lookups
0 MD and 40 lookup relationships.
2 MD
25 LU's...
2master detail and By defualt 40lookup relationship...
What is lookup ?
In Salesforce, lookup fields allow users to associate two records together in a relationship. For example, a user can associate a contact record to an account record using the Account Name lookup field. When users edit a lookup field, they need to find the right record to associate.
Lookup relationship
For custom objects - 40
For standard objects -25
Masterdetail relationship
2 for an object
So, what is your question?
it's been increased to 40 now
I Guess I am the one who is the first to give correct answer..So where is the T-Shirt....:)
Reach us out on salesforcehulk@gmail.com
If 2 master details then 38 look up
If 1 master details then 39 look up
If all 40 are look up then 0 master details
25 is the limet.
Hlo tell slowly ND neatly
40
Correct!
25 relationship in a single object
40 lookups and 2 master details
Total relationship-27
master relationship-2
lookup relationship-25
This is not correct, Amit.
Kindly speak slowly......
👍