Has anyone created?

[duchessofireland]

I'm looking for ideas on how to create a "daily diary". Just want to have
each day with a list of employees and what they worked on each day. Has
anyone created anything like this? Or does anyone know of any place that
might have a template for this? I've looked at the microsoft
templates....nothing. Any help or direction would be greatly appreciated.
Thanks

 

[Steve]

Consider .....

TblEmployee
EmployeeID
EmployeeFirstName
EmployeeLastName
<Other fields about an employee>

TblWorkType
WorkTypeID
WorkType

TblEmployeeWork
EmployeeWorkID
EmployeeID
WorkTypeID
WorkDate
WorkStartTime
WorkFinishTime

This should give you an idea about what you need. Post back with more
description of what work employees do and I can refine my suggestion for
you.

Steve

 

[duchessofireland]

This looks good. I'm not clear on what EmployeeWorkID is though. Basically
this is what I want....

7-1-08 (date)
Rex (employee)
Judy System (Location) - Check Reads (work performed)
Cedargrove System (Location) - Collections (work performed)

One of these for each employee. It is possible for each employee to perform
only one job, but is also possible for them to perform multiple jobs.

Thanks for your input.

 

[Steve]

TblEmployee
EmployeeID
EmployeeFirstName
EmployeeLastName
<Other fields about an employee>

TblWorkLocation
WorkLocationID
WorkLocation

TblWorkType
WorkTypeID
WorkType

TblEmployeeWork
EmployeeWorkID
EmployeeID
WorkDate

TblEmployeeWorkDetail
EmployeeWorkDetailID
EmployeeWorkID
WorkLocationID
WorkTypeID
WorkStartTime
WorkFinishTime

If there is a distinct set of worked performed such as Check Reads and
Collections, they would be your data in the WorkType field of TblWorkType.
Then as you enter employee work, you would have a combobox that gets its
items from TblWorkType.

Note I added a new table for location. If there is a distinct set of work
locations such as Judy System and Cedargrove System, they would be your data
in the WorkLocation field of TblWorkLocation. Then as you enter employee
work, you would have a combobox that gets its items from TblWorkLocation.

Note I added the table TblEmployeeWorkDetail. This table records one or more
jobs done by a specific employee identified by EmployeeID in TblEmployeeWork
on a specific date identified by WorkDate in TblEmployeeWork.
TblEmployeeWork and TblEmployeeWorkDetail are related through
EmployeeWorkID.
EmployeeWorkID is the primary key of TblEmployeeWork and a foreign key in
TblEmployeeWorkDetail. You would enter employee work records in these two
tables in a main form based on TblEmployeeWork and a subform based on
TblEmployeeWorkDetail.

The above table structure assumes that on any day an employee may work at
more than one location. If that is not the case an an employee will ALWAYS
work at the same location albeit possibly more than one job type, the
WorkLocationID should be moved from TblEmployeeWorkDetail to
TblEmployeeWork.

Steve
(e-mail address removed)