RE: Deleting only the active referential record
Hi,
You need to select the account 1: N relationship behavior as parental. In that case all child records irrespective of status active and Inactive will be deleted.
Are you want to restrict deletion of Inactive record?
I am asking as you have mentioned in brackets about Inactive records.
Unfortunately out of the box you can not control restricted delete based on status active or Inactive so either all childs are deleted , restrict delete , and remove link can be achieved using configuration behavior.
As in there is only three options available for delete criteria
-Cascade All
-Remove Link
-Restrict
So there is no option to restrict deletion of Inactive records or only active records.
Hope this helps.