I have several child tables that need to have related data deleted when a parent row is deleted. All tables are deleting data properly with the “Is a part of” REF link except for one. The only thing I can think of is that something about the way this table is populated (by an “add a new row to another table using values from this row” action) obscures the child relationship.
“Is a part of” is selected only in the User column.
Any thoughts?
Solved! Go to Solution.
Is “user” table reffed to another table too ?
I would also check in User column for suspicios stuff, like spreadsheet formula remainings etc.
The name of the Gsheet and table, perhaps it doesn’t like the underline.
Maybe even delete and recreate the category dash table, in worksheet and in appsheet, without VCs, without underline. Then test the delete. Then add one vc,retest, second VC,restest…
User | Count |
---|---|
35 | |
9 | |
3 | |
3 | |
2 |