I need to create an AfterUpdate action that modifies records in another table.
However, I am not having success and I think its because the table I need to modify is on the other side of a junction table.
So AfterUpdate [tbl_Groups] needs to modify records in [tbl_Commitments] which both have foreign keys in [tbl_Reviews]
Is this possible with data macros?
I have pasted a picture of my macro if that helps visualize what I want to do. Right now no records are being modified after an update.