[SalesForce] Master-Detail Relationship Limit

Salesforce says "As a best practice, don't exceed 10,000 child records for a master-detail relationship." here : http://na1.salesforce.com/help/doc/en/relationships_considerations.htm

What does "for a relationship" mean? Per Master object or per Master record? The former would be little too limiting but still the documentation is not clear for me.

Any help?

Best Answer

This statement

As a best practice, don't exceed 10,000 child records for a master-detail relationship.

Refers to record relationships, thus it is refering to a parent record with the number of related child records not exceeding 10,000. Thus it means 'per Master' record.

Related Solutions

[SalesForce] Increasing Dashboard Filter Option Limit

What we did was create another dashboard (cloned) and put the next set of '10 filtered' filters.

It's nice to know it's possible to get that raised to 50. - I'll have that requested :-)

[SalesForce] Master-Detail Relationship on Custom Object from Managed Package

You can, however create a trigger on a custom object from a managed package. Thus you can essentially fake a m/d

Given a custom object of bar__c in the managed Package namespace foo__ you would create a trigger on

trigger foo__bar__c (after insert, after update, before delete) {
//trigger logic here. Trigger.new will contain the managed custom objects that
// caused the trigger to fire.
}

A trigger that is fired after insert, after update and before delete has the ability to establish or delete any needed relationships with other objects.

You'll just need to find or create the related records, and populate a lookup field on them.

Best Answer

Related Solutions

[SalesForce] Increasing Dashboard Filter Option Limit

[SalesForce] Master-Detail Relationship on Custom Object from Managed Package

Related Topic