You need to sign in to do that
Don't have an account?
gregj777
Opportunity and Contract Object relationship - can't be done.
Can anyone help me with this frustrating issue. I am developing an application where I want to relate a number of opportunities with a contract and have the abilitiy to total sum the opportunity amounts and count the opportunities against this contract. I can't believe this can't be done. Am I the first person that's tried to do something like this?
You have to use a Lookup-Relationship and write a trigger to do the job of sum the opp amount and the counting! It's easy to achieve that!
I tried every which way to do this and even with a trigger(see below). I think the main problem is the MD relationship issue with Contract and Opportunity. I did create a lookup relationship with the trigger. The problem I am having with this trigger is that when one of the opportunities changes or deleted the Total Opp Amount in Contract Object does not update. I would be ecstatic if you can help me on this. As I have spent too much time and $ on this project.
Thanks,
Greg
Hi,
I think this could be solved with a simple relationship & trigger as Dirk mentioned above.
Here is the approach in wannabe code to give you a head start:
This example is missing a few bits and bobs here and there but should give you an idea how you can achieve the totalSum.
Hope this helps!
Florian
Could you help me finish this? And how much would it cost. I'm not a APEX programmer.