Hello everybody!
I’ve inherited a moderate size Employee database.
Main Employees table has a SSN as a primary key, but it is a “Text” data type.
I’m now told to delete social security numbers due to security reasons, change primary key to preferably autonumber or other unique value, but still keep last 4 digits as a new field.
tblMain structure
SSN;Text; primary key
LastName; Text
FirstName;Text
This table is in one to many relationship to 10 other tables.
Recently I selected “Cascade Update Related Fields” in order to update some incorrect numbers.
Here are my thoughts:
Using Right([SSN],4) I will create a new field in tblMain to track last 4 digits.
This field unfortunately has to be a “Text” in order to run append query.
As for changing SSN field to autonumber- no solution yet.
I could manually update SSN to unique text using first 3-4 letters of the name, but how to make users to apply same technique when entering new employee?
Any help is greatly appreciated!
Victor
I’ve inherited a moderate size Employee database.
Main Employees table has a SSN as a primary key, but it is a “Text” data type.
I’m now told to delete social security numbers due to security reasons, change primary key to preferably autonumber or other unique value, but still keep last 4 digits as a new field.
tblMain structure
SSN;Text; primary key
LastName; Text
FirstName;Text
This table is in one to many relationship to 10 other tables.
Recently I selected “Cascade Update Related Fields” in order to update some incorrect numbers.
Here are my thoughts:
Using Right([SSN],4) I will create a new field in tblMain to track last 4 digits.
This field unfortunately has to be a “Text” in order to run append query.
As for changing SSN field to autonumber- no solution yet.
I could manually update SSN to unique text using first 3-4 letters of the name, but how to make users to apply same technique when entering new employee?
Any help is greatly appreciated!
Victor
Comment