L
Lars Brownie
I have tblPerson related to tblAddress via a MxM table tblPersonAdres.
Referential Integrity and cascading deletes work fine. Except when I delete
a record from tblPersonAdres which links PersonA to AddressA. If that is the
only linking record where addressA's ID was present, addressA will become an
orphan, belonging to nobody. Is there some built-in option that will give a
message or should I build that myself? I would only want this option for the
Address, not for the Person.
Thanks, Lars
Referential Integrity and cascading deletes work fine. Except when I delete
a record from tblPersonAdres which links PersonA to AddressA. If that is the
only linking record where addressA's ID was present, addressA will become an
orphan, belonging to nobody. Is there some built-in option that will give a
message or should I build that myself? I would only want this option for the
Address, not for the Person.
Thanks, Lars