Delete all child siblings when deleting a parent

When I delete a parent from the TransferHeaders table, I was expecting that all the child items related to that parent gets deleted. They are not being deleted at the moment.

The following is how I have the Ref field in the child table: Transfers

Is it possible to have the child items automatically deleted when a parent item is deleted or should I mark the parent as deleted in a new field and then run a bot to delete both the children and the parent?

Please make the " Is Part of " setting on in the screenshot you have shared. It is the last setting in the screenshot you shared.. Also please read the description with it to know the constraints.

1 Like