I have 3 tables A->B->C. I need the status field change of C to change the status field of B. Note: B and C have different status values that cannot change.
So let's talk troubleshoot the Action. Did you create the report link field? If you put the Report link field on the C record, does it show a report of the single B to be updated?