He should, Im not sure. The tblEmplist has there name, station#, shift
Could it be a joining issue in my relationship >
Not likely a joining issue. If a table has incorrect data, as seems to be the case here, it's likely that you executed an INSERT query that was imperfect.
An autonumber column is a good way to identify each employee - it insures that no two employees have the same empID#. Therefore the Employees table rightly has this column, as your does (SHPK).
When you do INSERT into another table (in this case tblEmpHours), you have to be sure to INSERT that particular employee's ID# (SHPK). Instead, your tbleEmpHours has SHPK as an autonumber column - this is a second autonumber column which is therefore associating a new empID# with this employee. Not good. In fact, you' ve done multiple INSERTS for a given employee, resulting in MULTIPLE ID#s for him.
To start, then, SHPK column in tblEmpHrs should not be autonumber. (Every table should have an autonumber column though, because it comes in handy, I often name it AutoNum).
One question I have is, is the rest of the data in tblEmpHrs correct? Meaning, do you really want to have multiple entries for a given employee?