I have 3 tables; tblSalaries, tblEmployess, tblPayperiod


tblEmployees & tblPayperiod are joined to the main table tblSalaries.

Nb: tblSalaries have SalaryID, EmployeeID, PayperiodID, Groospay etc.........
This table contains salary records for Employees for all payperiods.

I only change the PayperiodID to create a new Salary Record on tblSalaries all other values are copied from the previous pay period records. How do i do this automatically so the in 1 click new salary records are created for all employees on tblSalaries without changing/deleting the previous records?