I have a donation database:
Table 1: Donation Data: donations as they come in online (user inputed information)
Table 2: Donors: each donors’ record which is linked to table 1 so you can see all their unique donations
Problem: user inputted information sometimes changes (e.g. Meghan Moore, Meghan E Moore, Dr. Meghan Moore), but I want the donation data to link ONLY to one record in the Donor Table (Meghan Moore)
I want to find a way to link both so that no matter what the user enters, the donation data gets linked to the proper donor record without creating a new record in the linked table because it looks like a “new” name.
e.g.
Table 1:
Meghan Moore ; $20
Meghan E Moore ; $50
Dr. Meghan Moore ; $100
Table 2: Meghan Moore ; $20, $50, $100
Is there a way to do this automatically (assuming I may already know some of the possible aliases) or do I have to always manually check for near duplicates and then assign to the proper donor record?
Thanks!
