Action to delete Parent, children and grandchildren

[Griff]

I have and app that has a parent ORDERS table, that has 4 Chidlren tables and one of those child tables has 3 grandchildren. All three of the have IsPartOf selected. None of the others do.

Only the Some of my users have been entering “practice” orders so I would like to be able to delete the order and all it’s children and grandchildren. I’d like to create an action that does it for me but I am not sure how to go about it. I am sure I’m not the first person to need this so I am looking for some guidance

[Griff]

I think I may have found a starting point: I will revert later if I still need help

Delete data in another table through action and workflow Questions

From your description, it appears the user would initiate the delete from table 1 by clicking a delete button on a row in table 1. The table 1 action must delete the row in table 2 first, then delete the row in table 1. If you delete the row in table 1 first, the action sequence will stop immediately, preventing you from then deleting the row in table 2. Delete this table 1 row For records of this table: table 1 Do this: Data: delete this row Needs confirmation?: OFF Delete this table 2 ro…