D
David Portwood
I have table T1 related 1:M to T2 which is related 1:1 to T3. When I delete
a record from T1, the corresponding records are deleted from T2 but the 1:1
related records in T3 are not. When I inspect the relationship between T2
and T3 I see that the three buttons (first is "Enforce Referential
Integrity") are disabled but Access recognizes that the relationship is 1:1.
Why doesn't the record in T3 delete as well when I delete the master record
in T1? Any idea what could be happening here?
In the form displaying T1 I suppose I could put code in the
AfterDelConfirm() method to delete the record in T3 but it seems like I
shouldn't have to do this. Am I misunderstanding something?
a record from T1, the corresponding records are deleted from T2 but the 1:1
related records in T3 are not. When I inspect the relationship between T2
and T3 I see that the three buttons (first is "Enforce Referential
Integrity") are disabled but Access recognizes that the relationship is 1:1.
Why doesn't the record in T3 delete as well when I delete the master record
in T1? Any idea what could be happening here?
In the form displaying T1 I suppose I could put code in the
AfterDelConfirm() method to delete the record in T3 but it seems like I
shouldn't have to do this. Am I misunderstanding something?