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.