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.