Mutiple entries on Timecard and Customer contacts

abbers_01

Registered User.
Local time
Yesterday, 23:49
Joined
Aug 31, 2007
Messages
45
I'm building a work order database that ties in with a time cards form and contacts database, etc... An issue I seem to be having for both Timecards and Contacts is multiple entries. ie I have a company with 3 contacts listed I've been struggleing to come with a way to have several contacts without having a field called contact1, contact2 etc... the same is true of my timecard, in a day a person will work on several projects however without having job1, job 2, etc... I've been unable to properly build a database that supports multiple entries. I'm new to this so any help to send me in the right direction we be great. I have been working with multiple tables, relationships and subforms but I'm thinking I just don't understand them well enough. I've read up on them but I just have't been able to figure this out.
 
Hey, welcome to the forum. Sounds like a Many-To-Many relationship, which is a little weird.
Say you have many employees who in the course of a day will work on many jobs. Here's a quick table diagram...

tEE (Employee)
EEID (PK)
Last
First
DOB

tLabour
LabourID (PK)
EEID (FK)
JobID (FK)
LocationID (FK optional, link table not shown)
Date
Hours

or
DateTimeStart
DateTimeEnd

If EE might work through midnight

tJob
JobID (PK)
JobName
Address
Site

So your Job and EE tables don't change much, but for every amout of time an EE works on a Job a new record is added to the Labour table. Since that table links to both Jobs and EEs, you are at the same time tracking time for a particular employee, and time allocated to the particular job.
Problems I've solved like this also need determined if the work was shop or site work. That data should also go in the labour table. I've linked to an imaginary tLocation table in case your workplace has multiple sites that work can occur.
 

Users who are viewing this thread

Back
Top Bottom