function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
MendyRMendyR 

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:

 

Contracts and Amendments

 

SamReadySamReady

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.