Payroll set up.

Discussion created by waynemartin on Mar 8, 2017
Latest reply on Mar 8, 2017 by philmodjunk

I have an employee table and have an hrs table. Employees create daily time records in the hrs table (every day is a separate record).


I do weekly payroll and I want to be able to create a payroll record for each employee that includes a list of the days he has worked in that week.


This is probably pretty easy but I'm at loss to know how to go about this, I know I will need a payroll table but how do I get the records for an employee from the hrs table into a new record in the payroll table? Using a portal?


Any help would be greatly appreciated, thanks in advance.