Hi,

Lets say, I have two tables, One is tbl_header and other one is tbL_detail. In tbl_header there is a field itm_code, in tbl_detail there is a field itm_det_code. both have relationship.

If i delete a itm_code in tbl_header it gives a constraint error. what i want is how to use the trigger in this scenario...
if i delete itm_code it should delete the item in detail table.

Please.
-Arjun