Tuesday, January 21, 2014

Salesforce: Master-Detail relationship (in detail)

One of the most advantage using Master-Detail relationship compare to Lookup relationship is Roll-Up Summary. In Master-Detail relationship, we can create roll-up summary field in master record to summarize / count data from child records.

Few items to notice when create roll-up summary field:
Parent record is locked
If you implement approval process with lock record, user will not able to create new child record if Sharing Setting in Master-Detail option is Read/Write.
Solution: change the sharing setting to Read Only.







Validation rule on parent record
If user not able to edit parent record and you have roll-up summary in parent record, user will not able to create or edit child record.
Solution: remove roll-up summary fields.

Can I change field type from Master-Detail to Lookup relationship?
Yes, make sure there is no roll-up summary fields in parent record, also in Deleted Fields (erase from Deleted Fields).

Can I change field type from Lookup to Master-Detail relationship?
Yes, all parent record should be not blank.

5 comments:

Supriya Sharma said...

Salesforce Consulting Company: Salesforce Integration Consulting at consilat.com

nick jones said...

thanks for sharing..
Server and Storage

JIMY said...

GOOD BLOG
Network security

Smith said...

Network Security Projects for CSE


JavaScript Training in Chennai



Project Centers in Chennai



JavaScript Training in Chennai


Martin said...

AllWeb4U Known As The Best Digital Agency in the Market. We deliver SEO (Search Engine Optimization), SMO (Social Media Optimization), ORM (Online Reputation Management) & Web Development Services.

Post a Comment

 
| ,