Wednesday, October 7, 2015

Difference between master-detail relationships and lookup relationships

Difference between master-detail relationships and lookup relationships



Master-detail relationship

Lookup relationship

You can define master-detail relationships between custom objects or between a custom object and a standard object (standard object must be the parent).

You can define a relationship between any two objects, standard or custom.

When a record in a master object (parent) is deleted, all the records in the detail object (child) that are related to that master record will be deleted.

When a parent object is being deleted, you can configure a child object to either clear the parent record value in the child record or prevent deletion of the parent record.

All child records must have a related parent record.

The parent record may not require a related parent record.

The ownership of the child record is determined by the related parent record. Child records do not have an owner.

Each child record has an owner and is not related to the parent record.

The detail record inherits sharing and security from the master record.

There is no security or inheritance between related parent and child records.

To relate an object to another object, no records should exist in the child object.

To relate an object to other objects, there is no condition on the number of records.

If you have the Roll-Up Summary field in the parent object, any create, edit, or delete action in the child record will trigger an edit action in the parent object. If you have a validation rule and other rules in parent object, the validation rules will trigger for the parent object.

You cannot create the Roll-Up Summary field in the lookup relationship using out-of-the-box Salesforce functionality.

Supports cross-object workflow. You can configure a field update action to update a field in the parent record using a value from the child record.

Does not support cross-object workflow.



To create a master-detail relationship for an existing object with records as the child object, you can initially define it as a lookup relationship, populate all parent fields for all records, and then change the relationship to a master-detail relationship.



You can build a many-to-many object relationship using two master-detail relationships in a single custom object, which is known as a junction object in that case. 





Thanks for reading...

9 comments:

Johan Yu said...

Great findings!

Natalya Murphy said...

This is a fantastic summary. I've been struggling to understand the differences between the two types and this has been extremely helpful. Thank you!

Unknown said...

VEEVA CRM
PREREQUISITE: Sales force certified Developer/Administrator
Veeva CRM is the first solution created specifically for life sciences and the unique needs of human, consumer, and animal health.
With advanced capabilities for planning and coordination across all channels, and predictive analytics through Veeva CRM Suggestions, Veeva CRM is the end-to-end solution that helps you adapt quickly to changing business needs and drive business growth.
BENEFITS
• Coordinate planning and execution across teams: Improve collaboration across key account managers, field reps, medical, and marketing to boost execution and deliver a personalized customer experience.

• Boost productivity while remaining compliant: Optimize sales utilization and alignment while ensuring field teams engage the right providers in the right activities.

• Drive continuous improvement faster: Enhance your customer engagement model by leveraging the latest process best practices, learning what works and evolving quickly.









COURSE CONTENT OF VEEVA SALESFORCE ONLINE TRAINING:
Module 1: Introduction to VEEVA
Module 2: Overview of Admin Console
Module 3: Data Access Security
Module 4: Application Configuration
Module 5: Creating Custom Objects.
Module 6: Veeva Configuration Utilities
Module 7: My Accounts Configuration
Module 8: Account Object
Module 09: Veeva Functionality Part 1
Module 10: Products and My
Module 11: Products Metrics Configuration
Module 12: Call Management Configuration
Module 13: Veeva Functionality Part 2
Module 14: Cycle Plan Configuration
Module 15: Sample Management
Module 16: Data Loading
Module 17: Territory Management Application
Module 19: VMobile Tablet
Module 20: Creating Reports and Dashboards
Module 21: VInsights Configuration
Module 22: Advanced Custome Setting



For Joining online training batches please feel free to call or email us.
Name ::saurabh
Email : saurabh@maxmunus.com
Skype id-saurabhmaxmunus
Contact No.-+91-8553576305
Company Website –http://www.maxmunus.com


abhi said...

Nice blog Thank you very much for the information you shared.

Web Development Internship in Bangalore

Website Designing Internship Internship in Bangalore

Internship Program

Anonymous said...

EFFECTIVE AND POWERFUL LOVE SPELL CASTER AND LOTTERY SPELL 2019 GBOJIESPIRITUALTEMPLE@GMAIL. COM OR WHATSAPP HIM :+2349066410185

Hi i am from USA I have just experience the wonders of Dr. gbojie love spell, that have been spread on the internet and worldwide, How he marvelously helped people all over the world to restored back their marriage life and get back lost lovers, and also help to win lottery. I contacted him after going through so many testimonies from different people how he help to bring back ex lover back, i told him about my husband that abandoned me about 8 months ago, and left home with all i had.. Dr GBOJIE only told me to smile and have a rest of mind he will handle all in just 24 hours, After the second day my husband called me, i was just so shocked, i pick the call and couldn't believe my ears, he was really begging me to forgive him and making promises on phone.. He came back home and also got me a new car just for him to proof his love for me. i was so happy and called Dr Gbojie and thanked him, he only told me to share the good news all over the world .. Well if you need an effective and real spell caster contact Dr gbojie Via email: gbojiespiritualtemple@gmail.com, gbojiespiritualtemple@yahoo.com or Call or WhatsApp: +2349066410185
website : http://gbojiespiritualtemple.website2.me/

Amit Kumar Singh said...


i am a freelancer and work according to contract, for more details contact us with the information provided below.
play game and win snapdeal lucky draw coupon 2019. contact us, play and win snapdeal lucky draw winner prizes.
lucky draw snapdeal contact number 6289379055 call to get more information
Lucky Draw Snapdeal costomer care number
snapdeal lucky draw contact number
snapdeal lucky draw contest 2019
snapdeal lucky draw 2019 list
snapdeal lucky draw contact number
snapdeal lucky draw 2019

Best Regards
snapdeal lucky draw winners 2019

All in One said...

Thanks for sharing such beautiful info, I think u will also share such type of info, I am very happy to that your way of consideration is very much good, I liked it.

Snapdeal Lucky Draw Prizes
Snapdeal Lucky Draw
Snapdeal Lucky Draw Prize
snapdeal online lucky draw
online shopping lucky draw
snapdeal lucky draw

sanjana said...

very much impresive...unique
do have a look on Social Media Marketing Companies in Bangalore. (SMM) is an exceptionally effective way to create a buzz for your website ,Social Media Marketing Companies in Bangalore India
Visit digitalmarketingseo.in

Nk787056 said...

Thanks for sharing such beautiful info, I think u will also share such type of info, I am very happy to that your way of consideration is very much good, I liked it.

Snapdeal Lucky Draw Prizes
Snapdeal Lucky Draw
Snapdeal Online Lucky Draw Prizes
Snapdeal Lucky Draw 2020
Snapdeal Lucky Draw winner 2020
Snapdeal Lucky winner list 2020

Post a Comment

 
| ,