Here's what i'm trying to do. I am selecting items from a stand alone table and trying to update another table that has a many relationship with another table. I know how to write a Insert Into Statement but how do i included a primary key from the one table into the insert statment.
If this is unclear i will try to clear it up. Thanks for the help.
Stand alone table One table
|
|
Many Table
Insert into the many table from the stand alone table and add the primary key from the one table where i'm on that record.
If this is unclear i will try to clear it up. Thanks for the help.
Stand alone table One table
|
|
Many Table
Insert into the many table from the stand alone table and add the primary key from the one table where i'm on that record.