We want to be able to have a calculated field in a custom object A, which is the result of adding field values together from custom object B and custom object C. So for example:

Custom_Object_A.field = Custom_Object_B.field + Custom_Object_C.field

I understand that the latest version of salesforce supports formulae fields that allow me to automatically calculate a value in one field based on the values in other fields, however as far as I’m aware this only works with fields associated the same object. We want to do something similar apart from the fields we want to use in our calculation are spread across different objects.

I’m sure there is a way to do this using sforce controls but I can’t find that many samples online. I was wondering if anyone has any sample code or suggestions about how I might go about implementing this functionality?

Also, we don’t want to have to click on a link to execute the sforce control. Instead, what we’d really like is to have the calculated field in our custom object A update/change automatically whenever the values in custom object B or C change. So we’d like to somehow attach or associate the sforce control with a field. Is there any way of doing this? Any help would be greatly appreciated.

Thanks

Karen