I have four tables right now. Associate list (name, department, shift), Associate daily information (date, clock in, clock out) , Associate task information (jobs, and related information), and Associate exception information (Daily problems dealt with).
The associate list will not change that much and has an auto number. The other three also have auto number fields but I also have date. As I will be going in daily and putting in more information, should I have the auto numbers of each table be the primary and foreign key's or use date as the date will always be changing?