Updating a related record via Set FieldPosted: August 4, 2011
If you want to update a field in a related record in a script, the easiest way seems to be to use the “Set Field” script step. So, for example, Set Field [program_enrolment_PERSON::ActiveDate; Get (CurrentDate)] will quite happily set the field even though the the field isn’t on any open layout. However, it’s important to do a COMMIT after the Set Field – the Commit will have the effect of saving the current record, plus any related fields.
I wasn’t at all sure about this, but was reassured by applying a validation test to the related field, that would run when an Commit was attempted but would fail (e.g. that it had to be zero), and, sure enough, the test is performed on the Commit of the parent record.