Hi,

I am starting to create a simple DB that is an HR program recording all potential employees walking through my office, as well as employee performance and monitoring, including his monthly timesheet, sales, and evaluations.

I am currently stuck on the latter, trying to figure out how to create these tables and their relationships to "Employees". What is the best way to record timesheets? Should i have a timesheet for each employee and every instance becomes "Day of Work of EMPLOYEE X", "EMPLOYEE X MONTHLY TIMESHEET", or should it be "THURSDAY, xx/xx/xxxx" and input all workers present that day? Then, how would be the smartest way to incorporate that into the individual employee's record making it accessible directly from the employee layout?

Also, as far as the layout is concerned, what is the best way to incorporate sales and performance forms, both separate forms and tables with a relationship to Employees, into the Employee layout?

Thanks in Advance, all responses are most welcome.

Jim

I think one table with time records for all employees for all dates would work. Summaries by people, by date, by day, etc are all possible from that.

As for me,i prefer use ActyMac DutyWatch Remote.It’s prog for computer monitoring.I use it’s for record all website visited my employees and i know what they do.