AnsweredAssumed Answered

Import/Update Records

Question asked by DiFi80211g on May 16, 2010
Latest reply on May 17, 2010 by philmodjunk


Import/Update Records


I have three tables, Table 1, 2 and 3.  Each table has a field in it called name.  What I want to do is:  If the name in table 1 is not in Table 3, add it.  If the name is in both Table 3 and Table 2, import the value of points into table 3, if it is not in table 3, add it. 


I hope this makes sense.  Table 1 and 2 have people's names and the points they got.  Table 3 has their name and a column for points from Table 1 and a column for points for Table 2.


Any suggestions on making this work?