How to use Button Click Event to insert data in two tables

Question

I want to insert data into two different tables but using single button click Event.
Example.

My first table Is Employee (ID,Name,Locatio)
  Second table is Manager (Id,Name,Location)
I am able to insert data into first table but not able to add data into both the tables by clicking on submit button at once.