MajP
You've got your good things, and you've got mine.
- Local time
- Today, 04:30
- Joined
- May 21, 2018
- Messages
- 8,555
Assuming you are logging times in and out for a job daily, you would have many times for many jobs, I would think your tables are
TblJob
--JobID 'PK
--JobName
-- Other fields unique to a job
tblJobTimes
-- jobTimeID ' autonumber
-- LogTime ' datetime
--TimeType ' in or out
--JobID_FK 'holds the PK for the Job table
1/1/2022 12:00 pm IN 1
1/1/2022 8:00 pm out 1
1/1/2022 07:00 am In 2
1/2/2022 11:00 am In 1
So I can log many in and out times for many jobs. Job 1, in 12 out at 8 on 1/1/2022. In again for job 1 on 1/2 at 11:00
TblJob
--JobID 'PK
--JobName
-- Other fields unique to a job
tblJobTimes
-- jobTimeID ' autonumber
-- LogTime ' datetime
--TimeType ' in or out
--JobID_FK 'holds the PK for the Job table
1/1/2022 12:00 pm IN 1
1/1/2022 8:00 pm out 1
1/1/2022 07:00 am In 2
1/2/2022 11:00 am In 1
So I can log many in and out times for many jobs. Job 1, in 12 out at 8 on 1/1/2022. In again for job 1 on 1/2 at 11:00