Creating New Records from 2 related table into a 3rd without Duplicates
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]
Set Field [Table2|weekName::week ; Table1::week]
Go to Record/Request/Page [Next ; Exit after last]
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?