Unanswered: Merging tables/ searching across multiple tables
I have a problem that I am stumped as to how to solve.
I have multiple databases with several people who are in more than one of the databases. I have merged all the databases into one file by creating a new file and importing all the old databases as new tables. My problem is that there are no unique identifiers that identifies each individual!!! I need to get a list of everyone who is duplicated in more than one table so that I can create a "key table" where everyone can be listed and assigned a unique identifier. I have no idea how to go about this short of manually typing in each persons name in each table to see if they come up.
P.S. I am very new to this so may need babied through the steps .