Question about tables...

[jyanks]

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.

 

[June7]

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.