So I have two excel sheets or tables , Donor and Gift , 1 Doner may give 0-M Gifts, the two tables are linked by email address which is unique in the Donor Table. I want to add Name from the Donor Table to the Gift table based on the email address.
I have created the two tables (from base CSV files) in Excel and linked them via email address using the Relationships function and that is all good.
I am at a loss to work out the function required to insert the name value from the Name field from the Donor table into the Name field in the Gift table based on the email address
Notes : all records in the Donor table have a valid name and email, the name field in the Gift table is null or blank