Insert into 2 tables with PK FK relationship

The simplest way to populate your database with test data.

Insert into 2 tables with PK FK relationship

Postby task » Mon Nov 07, 2011 9:39 am

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........
Posts: 2
Joined: Mon Nov 07, 2011 9:30 am

Postby Chris.Allen » Tue Nov 08, 2011 1:32 pm

have you tried assigning it as the foreign key generator?
Posts: 579
Joined: Thu Mar 12, 2009 3:17 pm

Return to SQL Data Generator Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests