I am creating a database for a nonprofit organization, so what I want to do is set up a Contacts table and a Donations table. I have an Excel spreadsheet of my Contacts that I can import, that part is easy. I also have an Excel spreadsheet that lists donations and contains the following fields: donor name, donation date, and donation amount. I want to import this data into my Donations table. My question is how do I make Filemaker match the imported donations with the donors in the Contact list during the importing process?
thanks in advance for anything that points me in the right direction!