title: Can I develop a trigger to put on two tables?
body: <p>I want to develop triggers that will be placed on both the customer and child tables that will track any record deleted and place them in the Audit_Log Table. </p>
  
  <p>This is audit log table</p>
  
  <pre><code>create table Audit_Log
  (
  audit_Id              int         primary key,
  Name            varchar(20)         ,
  Date_of_Birth   date                ,
  Gender          char(1)             ,
  Parish          varchar(20)         ,
  Mobile          integer             ,
  Mobile_Provider varchar(7)          ,
  age             integer, 
  age_cat         varchar(20),
  audit_action    varchar(30),
  audit_table     varchar(25),
  audit_date      date    default GetDate()
  )
  go
  </code></pre>
  
  <p>This is the child_list table</p>
  
  <pre><code>   create table child_list
   (
   child_list_Id              int         primary key,
   Name            varchar(20)         ,
   Date_of_Birth   date                ,
   Gender          char(1)             ,
   Parish          varchar(20)         ,
   Mobile          integer             ,
   Mobile_Provider varchar(7)          ,
   age             integer, 
   age_cat            varchar(20)
    )
   go
  </code></pre>
  
  <p>Customer table has fields (Offer_date, Customer_id, Offer_value, Product_name, Acceptance_status, Employee_ID)</p>