Add new Recordset using Recorset by Query

[gailoni]

I have 3 tables; tblSalaries, tblEmployess, tblPayperiod


tblEmployees & tblPayperiod are joined to the main table tblSalaries.
Currently I am manually creating new salary records for different pay periods.

What code do I use to automatically create new salary records on tblSalaries for the next pay period. Nb: tblSalaries have SalaryID, EmployeeID, PayperiodID,etc.........

Please help as doing this manually every forthnight is becoming tedious for me.

[gailoni]

I have 3 tables; tblSalaries, tblEmployess, tblPayperiod
tblEmployees & tblPayperiod are joined to the main table tblSalaries.

Nb: tblSalaries have SalaryID, EmployeeID, PayperiodID,etc.........

Currently I am manually creating new salary records for different pay periods by copying the previous values to create the new salary record and just changing the payid field to indicate the new payperiod. This creates the new record.

What code do I use to automatically create new salary records for all Employees for the next(new) pay period on tblSalaries??