AnsweredAssumed Answered

Creating New Records from 2 related table into a 3rd without Duplicates

Question asked by ClaireCollin on Apr 25, 2013
Latest reply on Apr 25, 2013 by philmodjunk

Title

Creating New Records from 2 related table into a 3rd without Duplicates

Post

I have Table1, Table2, and Table3. Following the steps below I was able to create new records from Table1 into Table2.

     "Create a new Tutorial: What are Table Occurrences? that refers to Table 2 (In manage | Database | Relationships, select Table 2 and click the ++ button.)

     Link it like this:

     Table1::week = Table2|weekName::week And
     Table1::Name = Table2|weekName::name

     Enable "allow creation" for Table2|weekName in this relationship.

     Then this script will create one new record in Table2 for each record in the current found set of records in Table1:

     Go to Record/Request/Page [First]
     Loop
       Set Field [Table2|weekName::week ; Table1::week]
       Go to Record/Request/Page [Next ; Exit after last]
     End Loop

     I used SKU in place of Name"
      
     Now I need to create records from Table3 into Table2 without duplicating the same SKU and Week combination. 
Table3 (imported data) uses a similar field structure (SKU, Name, Week, Shipped) as Table1 but may or may not have different SKUs and Weeks. Is there a way to find the unique SKU and Week records from Table3 and add those records to Table2?
      

Outcomes