Thank you, Kevin Robertson and Sami Shamma, for helping me previously! I really do appreciate it! If I could afford to subscribe to Computer Learning Zone I definitely would!
One more question that I can't seem to find an answer to anywhere: I guess it would be, am I able to use a foreign key instead of a primary key in my tables?
I have an employee table, so my primary key is of course the EmployeeID (AutoNumber) - but - this database will be used to enter employees in by their employee numbers. So my employee table has an EmployeeID field and a "ClockIn"(Number) field.
When I add a foreign key to another table, say my "ViolationT", can I use "ClockIn" instead of "EmployeeID" to relate back to my employee table? Like to link it to THAT employee? And if so, do I index my "ClockIn" field in the Employee Table Design as Yes(NoDuplicates)? or Yes(Duplicates OK)?
I hope that makes sense - - I'm trying to make this easy for my users to enter an employee and link a violation to that particular employee - I just want to be sure I can do it this way without messing everything up?
Again, thank you all for all your help so far!!