Competition: What’s your favorite Redgate tool? Enter now.

Insert into 2 tables with PK FK relationship

tasktask Posts: 4
I am trying to insert 1 record of data into 2 tables - the first table assigns the user a person_id and I want then for this person_id to link the 2 tables and the record to have a relationship through this id. At the moment when I go to generate the data 2 rows are inserted with 2 different person_id.

Any help would be much appreciated........

Comments

Sign In or Register to comment.