Create new record via relationship
Here's what I'm trying to do and finding myself unsuccessful:
Table 1: Donor ID, Donor Name, Donor Address, Donor Phone
Table 2: Donor ID, Jan Gift, Feb Gift,March Gift
The two are linked by Donor ID via a '=' relationship
I get a weekly excel document that has Donor ID, Jan, Feb, March that I import into table 2.
Here's what I want to do: When importing, If Donor ID in the import doesn't come up in any records in Table 1, then create a new record in Table 1 with that new donor ID.