Forum Discussion

ChadBrandmire's avatar
ChadBrandmire
Qrew Assistant Captain
8 years ago

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.

12 Replies

Sort By
Show More
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    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.
  • ChadBrandmire's avatar
    ChadBrandmire
    Qrew Assistant Captain
    8 years ago
    Sorry for the delayed response. 
    Made the change and all appears to be working.
    Thanks