View Single Post
  #3 (permalink)  
Old 05-11-09, 06:53
kfc@vd.dk kfc@vd.dk is offline
Registered User
 
Join Date: Jun 2003
Posts: 80
I still need to be able to delete in both tables. Some times I delete records in table A (and needs corresponding data i table B to be deleted as well). And some times I delete records in table B (and needs corresponding data i table A to be deleted as well).

Maybe I don't understand your proposal correctly, but the foreign key with cascading deletes seems to me to be working the same ways as a delete-trigger - and therefore only one of the ways.
Reply With Quote