Thanks a lot for your suggestions and advices, they are very useful,

Well it's a long story, I have 2 tables, one is general, one is detailed, when I have...

OK Andy,

Thanks a lot for answering to me, just one more question, how works an instead of trigger? is it as a before delete trigger?, actually my problem or question...