Forum Discussion
Lookup Table change with time
Excuse my title, as I wasnt sure what to name this topic. I have a lookup table that uses an employee number to tell what budget group someone is in. One of the employees here is moving to a differen...
Bump
ChrisMendoza
Resident Rockstar
Resident RockstarAnonymous -
Does your organization not utilize an additional Position_Code or similar to make a unique key on EmplID?
0001 is John's EmplID
00010 is John's "1st position"
00011 is John's "2nd position"
If not, you could create this artificially then flag 00010 as inactive retaining those records and 00011 as active.
My organization does identify EmplID & Position_Code; this is my Key that is used for uniqueness.