Auto remove cell data after reference key is removed

[ckng6218]

Let make my question easy, i have table A employee list that content 2 columns that is staff name and staff ID(key value),  table B is asset list that content 4 columns that is asset ID(key value), asset type, staff name and staff ID, i set a reference at table B for staff ID column that point to table A staff ID column, i have configure the dereference for both table and everything is working fine. My question is after i remove the specific row at table A, i want the cell data from staff ID cell and staff name cell at table B is auto remove without remove related entire row. Im still new for appsheet, hope someone can help me with this

[TeeSee1 · Accepted solution]

@ckng6218 

Welcome to the Community

One way to do this is...

1. TABLE A: Create an action to call an action on TABLE B.
   • Execute an action on a set of other rows (Reference Action)
   • Referenced Rows = [Related TABLE Bs]
   • You can pass [who to transfer to] <- EDITTED: you do not need this...
2. TABLD B: Create an action to clear [staff ID] and [name]
   •  Data: set the value of some columns in this row
3. TABLE A: A Composite action to call 1, 2 and the generic DELETE action
   • Execute a sequence of such actions on one row (Composite Action)

See if this works for you.

You should also read the below if you haven't already

https://help.appsheet.com/en/articles/953637-actions-the-essentials

Try to work it out and you can ask additional questions if you need further clarification.

[ckng6218]

Thanks! im not deep enough explore for the behavior feature, appreciate for your tip