Hi,
I've tried searching the forum but not quite sure what to look for.
I have a form which displays a table in datasheet view:
Day: (Date)
Shift: (Text)
WorkerID: (Looks up worker from a different table)
Shifts are pre-entered and then workers are assigned to shifts as and when.
I'm trying...
Hi,
Thanks for your reply.
I appreciate what I am trying to do is probably beyond the realms of a novice.
I've tried to attach a zip of the database but it's too big.
The basic table layout is
tblWorker:
WorkerID
First Name
Last name
tblSite:
SiteID
Site name
tblShift:
ShiftID
Date...
Hello,
I am a complete Access novice but have been asked to create a database for work.
I work for a kind of employment agency which sends support staff to various sites throughout the city.
So far I have 3 tables:
Worker
Site
Shift requests
and have linked workerID and siteID into...