Status change between related tables
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.
Forum Discussion
The record that you want to update in Sell sheets (B) is the Parent of (C). The Parent of C will be [Related sell sheet], so that is the field that you need on the left side. The right side is the record that you want that to match to which will be the [Record ID] field in Sell sheets.
So maker that adjustment and see if the Parent sell sheet record shows on the report link field on C.
So maker that adjustment and see if the Parent sell sheet record shows on the report link field on C.