Incorporating multiple usernames or alternate names

[mpreston14]

Hello,



What is the best way to incorporate multiple names?

I have a table where I have all the users entered, First, Last, DOB etc.

I import 3 disparate source files that only provide me some first and last, BUT could provide usernames for each person in the file. Each of the 3 sources would have a different user name.

Because I have several duplicate names that are unique persons, I am going through a lot of manual manipulation to get the data files imported and matched to the user table that is already built.

My question is what is the best way to incorporate the alternate user names so that if I import File A with User Name xxxyyy it will be applied to the John Smith with xxxyyy as his "Source A User Name" and not the John Smith with cccddd as his "Source B User Name" ? Is it one User Table with all three additional usernames or one User Table with Three distinct Username Tables?

My user table has unique ID's already as the PK.

I would love to be able to link all Users with their alternate User Names with as little to no manual manipulation, ie import it all into access and it magically works

Thanks!

Mike

[Beetle]

I would add a child table to store the additional info for each user.

tblUserNames
UNID (Primary Key)
UserID (Foreign Key to tblUsers)
UserName
SourceFile << some value to indicate which source file this user name is associated with.

Then you could reference this table when running updates to sort the data.