Update checkbox on Opportunity page when Product is added under it
I have a situation where I need to update a checkbox on Opportunity page when a particular Product is added under Product Revenue section. And conversely when the product is removed from the Oppty, I need to uncheck the field on Oppty page.
1. If I compose the workflow on Revenue object, I do it on the trigger "When New record saved", I cant update the checkbox on the Oppty page.
2. If I compose the workflow on Oppty object, I do it on the trigger "Before Modified record saved". However this won't help because the Last Modified value doesn't change when an associated item is added or removed; only when something is modified on the main Oppty page the last modified changes.