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
|
|||
|
|||
Question about tables...
So I have two tables- people and shifts. Shifts contains information about
what is sold during each shift, and people contains employee information. What I'd like to do is to eventually create a report that is able to show who showed up to their shifts and who didn't. The problem is that I don't have any way of storing who is supposed to be working at a certain time (Their shift information) since it's the same every week. In order to store that time, I thought of only one option- I could create a ShiftTimes table or something of the sort and have it store each shift time. Does that seem like a reasonable way to complete my task? I was just thinking that to make the report I'd then just have to find out which ShiftTime ID's weren't covered over the past week... If anyone has any other way they could think of doing this, that'd be great. As for some background information, each person has exactly 1-1hr shift every week. |
#2
|
|||
|
|||
Question about tables...
Seems your Shifts table would be more appropriately titled Sales with the
shift sold in being data about the sale. Could table People have field(s) for the employee's shift (either a period code or from/to fields)? Then you have a table for shift history, similar to payroll records. "jyanks" wrote: So I have two tables- people and shifts. Shifts contains information about what is sold during each shift, and people contains employee information. What I'd like to do is to eventually create a report that is able to show who showed up to their shifts and who didn't. The problem is that I don't have any way of storing who is supposed to be working at a certain time (Their shift information) since it's the same every week. In order to store that time, I thought of only one option- I could create a ShiftTimes table or something of the sort and have it store each shift time. Does that seem like a reasonable way to complete my task? I was just thinking that to make the report I'd then just have to find out which ShiftTime ID's weren't covered over the past week... If anyone has any other way they could think of doing this, that'd be great. As for some background information, each person has exactly 1-1hr shift every week. |
Thread Tools | |
Display Modes | |
|
|