AnsweredAssumed Answered

Create new record via relationship

Question asked by EddieBaker on Oct 19, 2012
Latest reply on Oct 20, 2012 by philmodjunk

Title

Create new record via relationship

Post

     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. 

Outcomes