Need Recommendations on setting up new table imported from main database table
My main study database table has about 70 fields, of which includes last name and first name of the investigator. Each investigator has multiple study records and that requires duplicate entry of investigator name. I decided to created a new table with investigator info and imported those records, removed the duplicates and created a serial number for each investigator as well as a Uniquename (LastName & FirstName). My question is do I delete the investigator name form my main study database and how do I link each study record to the correct PI? And for future entry of new investigators, what is the best method do that, a validated list and new entry option?