How to delete children items in another table with an action?

[Jonathan_zorita]

I want to add a button that deletes the items of a sale, and also the sale itself. For that I made a group action that executes 2 actions:
1: Delete items from the Sale in the child table
2: Delete current record in current table
To do this, create an action in the Sales table that executes an action on a set of rows.
Referenced Table: ItemsVta
Referenced Rows: [Related ItemsVtas]
Referenced Action: Delete
When executing, the action fails and says that the sale items are required. What should I put in place of [Related ItemsVtas]?
I tried to do a SELECT:

SELECT (ItemsVtas [ItemVta Id], [Sale Id] = [_ THISROW]. [Sale Id])

But it didn’t work out either.

What would be the correct way to delete a record and its children?

[Rifad]

Try enabling is a part of in child table ref column

[Rifad]

Jonathan_zorita:

When executing, the action fails and says that the sale items are required.

Can you disable REQUIRE and try again ?

[Jonathan_zorita]

I did not realize where that message came from, I checked that table and slice allowed to delete, but I did not think about that.
The problem is that it must be required that there are items when creating the sale, but it has to allow deleting the items and then deleting the sale with the next grouped action.
I will have to put some condition in Required
Thank you very much for making me observe that detail!