Help

Re: Creating linked tables with user-inputed "fuzzy" data

1879 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Meghan_Moore
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

11 Replies 11

@JonathanBowen and @Bill.French: Very cool!

Long wait; 5 years+ on many things that were foregone conclusions. Fuzzy linking? Perhaps late 2024?