Hello everyone, I just have a very basic question that seems to not be answered anywhere I could find online.
I have two tables tblEmployee(name, address, phone, etc.) and tblEmployeeDates(this is for a start date, probation end date, termination date). I have employee ID as the primary key for tblEmployee, I also have employee ID as the primary key for tblEmployeeDates. I know it will work but is it good practice? I could make a field in tblEmployeeDates called dateRecordID or something like that as the primary key and use employee ID as a foreign key I suppose.
Any input would be greatly appreciated.
-Dave