I was surprised to find that if I deleted a linked record from the ‘Parent’ side of a relationship that the child record was still present in the other table - but orphaned.
I can see how this behaviour is desirable if the link is set up to allow links to multiple records but in a one to many I would expect the record to be deleted rather than Orphaned.
This is even more the case if the ‘parent record’ is deleted - and I note that in this case the record is orphaned as well.
This leads to a messy database and can be very confusing for users.
Could we have options in the link definition to enable cascade delete and also delete record when link deleted?