Update Query - Add records to a join table

brharrii

Registered User.
Local time
Yesterday, 23:46
Joined
May 15, 2012
Messages
272
I have 2 tables that are joined by a many to many table:

tblProductInfo
- ProductID

tblProductLinerMM
- PLProductID (FK to [tblProductInfo].[ProductID])
- PLLinerID (FK to [tblLiner].[LinerID])

tblLiner
- LinerID


I have a range of products that each use 2 liners. An inner liner and an outer liner. I need to add 2 records per product to the tblProductLinerMM table.

for example

tblProductInfo has the following records:
- 2138557
- 2378954
- 4387657

tblLiner has 2 liners in particular that relate to these products:
- L5475
- L5468

I need to create the following records in tblProductLinerMM preferably with the use of a query :
- 2138557 | L5475
- 2138557 | L5468
- 2378954 | L5475
- 2378954 | L5468
- 4387657 | L5475
- 4387657 | L5468


Does anyone have any idea how I might achieve this?

Thank you
 
Last edited:

Users who are viewing this thread

Back
Top Bottom