Hello,
I have imported a list from Excel with 25K records. Each row has Name information (FN,LN,Co,Address,) plus Payment information (TransDate, Amount, GL) If a person paid more than once their Name information is repeated with the new Payment information. So the list contains many duplicate name entries.
From this table I would like to create a Name table that stores each unique person only once and links to a Payments table which shows one or more payments that each Name record has given.
How in Access can I accomplish this? Thanks so much for your help. Tim