C
cmccluskey
Hello,
I have created a timesheet for a small business. The timesheet works
well, except we occasionally have problems with employees entering
their time twice for the same day. The configuration is basically
date worked, employee name, total hours and then several sections with
sub categories for hours worked (IT/Retail/Etc.)
The problem I am having is figuring out how to prevent duplicate
entries. If I try to make the date or employee filed unique, I have
problems as several employees may work the same date and employees
work more than one date. Does that make sense at all?
I am wanting to prohibit duplicate entries for a given employee on a
given date only. Can anyone help with this?
Thanks!
Chad
(e-mail address removed)
I have created a timesheet for a small business. The timesheet works
well, except we occasionally have problems with employees entering
their time twice for the same day. The configuration is basically
date worked, employee name, total hours and then several sections with
sub categories for hours worked (IT/Retail/Etc.)
The problem I am having is figuring out how to prevent duplicate
entries. If I try to make the date or employee filed unique, I have
problems as several employees may work the same date and employees
work more than one date. Does that make sense at all?
I am wanting to prohibit duplicate entries for a given employee on a
given date only. Can anyone help with this?
Thanks!
Chad
(e-mail address removed)