Roll up fields on a lookup relationship - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Fixed Assets DevFixed Assets Dev 

Roll up fields on a lookup relationship

We are adding a new custom object that should really be a master-detail to an existing custom object.  However because the existing object is in a managed package we are dis-allowed from creating the master detail relationship.

We need two numeric fields that will be a roll-up total of a field in the existing object.  How best to handle this?  My thought is to create a lookup relationship to the new object and write some APEX to update the roll-up field on the new object.  Any other thoughts from the community?
Jayant JoshiJayant Joshi
As per you comments, since in this case you cannot have a Master Detail relationship so i guess Apex Trigger would be the only option. An update trigger should update the field on the first object.
Joseph BauerJoseph Bauer
Rollup Helper allows roll ups from lookup relationships: http://appexchange.salesforce.com/listingDetail?listingId=a0N30000009i3UpEAI