Trgger Question

Hi I have four tables A,B,C, and D with prod_number. I am trying to write a trigger to delete prod-numbers from B,C, and D if I delete a prod_number from A. Since I can only have one delete triggrer on A , I have the following: create trigger ....... delete on A ....... for each row ( delete from B; delete from C; delete from D;) Is it possible to do the above or do I need a stored procedure (called from a delete trigger) that deletes from B,C, and D (since it is not possible to have three delete statements in create trigger statement)? (I tried the above, but I am getting error creating the trigger). Anther alternative I have is to write three triggers like the following: 1. Create trigger ... delete on A for each row (delete from B); 2. Create trigger ... delete on B for each row (delete from C); 3. Create trigger ... delete on C for each row (delete from D) Thanks in advance for your help. Keith