1 Reply Latest reply on Apr 25, 2013 9:38 AM by philmodjunk

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

    ClaireCollin

      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?