Hi all,
First off, I'll admit that I'm rather new at this, so please let me know if I'm doing this right.
I'm building a very simple database to keep track of the clock-in and sign-out times for a list of employees.
I have tbl_checkin that contains the IN time, tbl_checkout to manage the OUT time, and tbl_employeenames for name reference. I put the checkin and checkout date/times in separate tables since they are to be filled automatically according to system time, i.e. =Now()
What I'm thinking of is this:
tbl_Checkin
Checkin_ID
Employee_ID
DateIN
TimeIN
tbl_Checkout
Checkout_ID
Employee_ID
DateOUT
TimeOUT
tbl_EmployeeNames
Employee_ID
Employee_Name
.. which might not be the best solution as it becomes a little difficult to link them together, especially if DateIN and DateOUT are different.
Any help would be appreciated. Thanks!
First off, I'll admit that I'm rather new at this, so please let me know if I'm doing this right.
I'm building a very simple database to keep track of the clock-in and sign-out times for a list of employees.
I have tbl_checkin that contains the IN time, tbl_checkout to manage the OUT time, and tbl_employeenames for name reference. I put the checkin and checkout date/times in separate tables since they are to be filled automatically according to system time, i.e. =Now()
What I'm thinking of is this:
tbl_Checkin
Checkin_ID
Employee_ID
DateIN
TimeIN
tbl_Checkout
Checkout_ID
Employee_ID
DateOUT
TimeOUT
tbl_EmployeeNames
Employee_ID
Employee_Name
.. which might not be the best solution as it becomes a little difficult to link them together, especially if DateIN and DateOUT are different.
Any help would be appreciated. Thanks!