|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 22nd, 2008, 11:41 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Has anyone created?
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 
|
|
#2
July 23rd, 2008, 01:44 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Has anyone created?
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" wrote in message ... 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
|
|
#3
July 23rd, 2008, 01:02 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Has anyone created?
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" wrote: 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" wrote in message ... 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
|
|
#4
July 23rd, 2008, 03:40 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Has anyone created?
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 "duchessofireland" wrote in message ... 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" wrote: 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" wrote in message ... 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
