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
Well, you have two choices, I suppose. The first is to do summary field of the # of children at various statuses and then use that in a formula to calculate the status of B.
But if you want a change done based on a change to "C", you can create an Actin to edit records. But to do that you will need to set up a Report Link field on C which links one the Left side of the setup [Related B] to the field on B of [Record ID#].
Then you can set up an Action.
But if you want a change done based on a change to "C", you can create an Actin to edit records. But to do that you will need to set up a Report Link field on C which links one the Left side of the setup [Related B] to the field on B of [Record ID#].
Then you can set up an Action.