title: When inserting into one table, insert into others with the same values
body: <p>I have 3 tables:</p>
  
  <p>users, contact and pay_roll.</p>
  
  <p>All of the tables share the column user_id which is the primary key and is auto incrementing on all of them, when I insert a new user into the table "users", is there a way to add a blank row to both contact and pay_roll to then be updated later?</p>
  
  <p>My SQL query so far:</p>
  
  <pre><code>INSERT INTO dbo.users (fName, lName) VALUES ('Kieron', 'Oates')
  </code></pre>