I have a junction object created between Accounts and Contacts called Affiliations. Any time a user updates a particular field on an Account record(ACO CMS Pending checkbox = false), I need to update a field on all of the related Affiliation records (ACO Participation = Yes). Could anyone point me in the right direction to getting this working? I tried a cross-object workflow rule, but it didn't appear to be working because I need to update the child records and not the parent record, so I am assuming I need to write a trigger. Unfortunately, this is my first so I could use assistance. Thanks!