We're finding that orphaned records are accumulating at a rapid rate, especially as we increase our use of Apps Scripts, and it is having a negative effect on data integrity (as well as wasting time sorting user error from intentional orphaning).
It would be great to have the option to automatically delete all child records upon the deletion of the parent, or to enable App Script to accomplish the same.
Lucas Ward commented
I second this, as I have run into similar issues. The problem it would seem, come with deleting records that have more than one link to a parent record. In other words, although it is possible to use app scripts currently to delete child records that are only linked to the parent record table the app script is run from, I would love to see the ability to delete the child records regardless of their other relationships.
Or at least a short tutorial on how this can be achieved using app scripts!