I have database Salary.dbc It is having four table 1.empmain 2.earnings 3.recovery 4.loans advance.

how to insert input value(data entry) in to multiple table at same time?

for example i have entered data in my empmain form, the empID will be inserted into all my four table at same time.