MS Acccess - Join question
tldr: Basically, need Table 1 in the example below to repeat SKU 123 to accomodate Table 2's two lines of data. So when the update query runs it picks up both shipped dates and not just one.
Hi, I am trying to update information in table1 with data from table2. In some cases, table2 could have multiple rows of data that relate to one row in table 1.
Based on the example below, I am trying to have Table 1 duplicate the row for SKU 123 twice to accomodate Table'2 two references for SKU 123. The same for SKU 789. The only one without an issue would be SKU 456. I assume this is how I am setting up the joins but man that stuff is confusing. I am no access expert (obviously), just self taught whatever I could from google but can't find anything about my specific issue.
This is a very basic example. There are 20 fields in each table, etc.
Ex.
Table 1
SKU Shipped on
123
456
789
Table 2
SKU Shipment# Shipped on
123 1 1/10/2014
123 2 1/15/2014
456 1 1/12/2014
789 1 1/14/2014
789 2 1/15/2014
789 3 1/16/2014
Hi, I am trying to update information in table1 with data from table2. In some cases, table2 could have multiple rows of data that relate to one row in table 1.
Based on the example below, I am trying to have Table 1 duplicate the row for SKU 123 twice to accomodate Table'2 two references for SKU 123. The same for SKU 789. The only one without an issue would be SKU 456. I assume this is how I am setting up the joins but man that stuff is confusing. I am no access expert (obviously), just self taught whatever I could from google but can't find anything about my specific issue.
This is a very basic example. There are 20 fields in each table, etc.
Ex.
Table 1
SKU Shipped on
123
456
789
Table 2
SKU Shipment# Shipped on
123 1 1/10/2014
123 2 1/15/2014
456 1 1/12/2014
789 1 1/14/2014
789 2 1/15/2014
789 3 1/16/2014