Delete rows with related column

[Filip_Kuna]

Hi,

I am working on a app, where I have a order which is connected to 2 another tables through order ID. I would like to create an action that can delete rows from all tables related to this order ID.
I would like to have that option only in order detail.
Is there a way to execute multiple actions that are connected with a specific column data?

Thanks for your time.

[Koichi_Tsuji]

You should have system generated Delete action in child table.

Then on your parent table, you create action something like this.

[Suvrutt_Gurjar]

You could in general try using reference actions on those connected tables through order id and use group actions to execute all those in sequence.

[Steve]

If the child table has an Is a part of relationship to the parent table…

then the child rows will automatically be deleted when the parent row is.

[Victoria_Winde1]

Hi, what if i have a virtual column to a referenced table and i don't want to delete the data from the referenced table in my action. I have a Bot set up to "When the date is older than today, move the row to another table [past bookings], then delete the row in the [master bookings]   table. This is working but its not carrying the data over from the referenced table (which is my [updates] table"