Designing Employee Master Table
Designing Employee Master Table
(OP)
I am using Access 2007, and just starting to design a database.
I am curious as to how other programmers/techicians account for maiden names and name changes of employees. My primary key will be the employee number obviously but when I produce queries and reports I would like to be accurate for the employee first name and last names.
Do you create/maintain a sub-table that is linked to the main employee table, or do special coding on-the-fly?
Any help would be greatly appreciated, even references to other Q and A, or web-sites.
RE: Designing Employee Master Table
http://r937.com/relational.html
Hope This Helps, PH.
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?
RE: Designing Employee Master Table
Why do you care about what their name was historically since it is not a key into your table nor, presumably, in any related tables?
If, for some reason, you do care then
Then
CODE
RE: Designing Employee Master Table
Never give up never give in.
There are no short cuts to anything worth doing