You need to sign in to do that
Don't have an account?
MendyR
Child Record updates Master via Datecreated and ID?
These objects are both Custom (even though one is named Contracts).
I'm trying to get the Master Contract date field updated by the Stipulated End Date of the most recent Amendment. The most recent Stipulated End Date might be EARLIER than a previously Stipulated End Date.
Here's what I have so far:
From what I understand of your images, you want the "Actual End Date" on Contracts to be updated to the last "Stipulated End Date" of all child Amendments, correct?
If this is the case, why not make a trigger that every time an ammendment is created or updated to query for all ammendments related to the parent contract and set the parent contract's actual end date based off of the date comparison of your results.