Can this be done?

[sammy]

Just wondering if this can be done in access
have an employeestable like this
EmpID autonumber
fname
lname
location
ShiftID (FK to shiftstable)

Shiftstable
ShiftID (PK)
Mondaystart
MondayEnd
rest of work days

What I am wondering about is if theres anyway I can create a table with all
day's hours with a yes/no filed to show if the employee is busy or idle?

Thanks

 

[tina]

well, i didn't really understand your question about hours of the day, when
your Shifts table seems to be only setting the parameters of each shift - a
start time and end time?

at any rate, your Shiftstable is not normalized. to define each shift, and
the start/end times of each shift for each workday of the week, you need two
tables, as

tblShifts
ShiftID (pk)
ShiftName (or ShiftCode, or however you identify each shift. commonly:
first, second, third shifts. or sometimes, day, swing, grave shifts.)
<any other fields that describe a shift, such as a standard shift
differential, perhaps.>

tblShiftParameters
ParamID (pk)
ShiftID (foreign key from tblShifts)
DayOfWeek
StartTime
EndTime

relationships are:
tblShifts.ShiftID 1:n tblShiftParameters.ShiftID

hth