I have two tables:
Customer has PhoneID as foreign key which points to PhoneID pk in Phone table.
If a customer record is deleted, i want the associate phone record in phone table to be deleted also. Obviously, i can not use ON DELETE CASCADE because in my case, i'm cascading deletion in reverse manner.
Any idea what to do?