Assuring all parents get children

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

Assuring all parents get children

Postby dlutz » Wed Jul 23, 2008 9:43 pm

I have a Case table and a CaseParty table. Relationship is 1-N. CaseParty table holds FK to PK of Case table.
The Case table is generating 100 rows and the CaseParty table is generating 300 rows. All Case table rows must have a CaseParty row - a case without a party makes no sense.
For the CaseGUID column in the CaseParty table, setting the Population method to 'Repeat key values at random' leaves me with 8 cases with no party - not acceptable.
If I set this property to 'Set key values between 1 and 5 times' I get 'The generator for column CaseGUID could not generate any more values.' on the CaseParty table.
Can somebody inform what I need to do to get all Cases to get a Party AND get all the Party rows I request?
Much appreciated. BTW, the output of this product is being MUCH appreciated in the shop where I work. We look forward to supporting you as the product evolves into ever greater usefulness over time.
dlutz
 
Posts: 8
Joined: Sat Feb 16, 2008 4:54 am

Postby dlutz » Wed Jul 30, 2008 7:01 pm

I am kind of surprised by the lack of any response to this post. Does this mean that nobody has ever encountered this problem? Or am I not clear in the description of the problem?
dlutz
 
Posts: 8
Joined: Sat Feb 16, 2008 4:54 am

Postby benhall » Thu Jul 31, 2008 4:40 pm

Hi David,

Sorry for the reply in getting back to you.

The only way I can think of doing this would be to have 3 to 3, this would mean every case would have a party.

Would this meet your requirements?

Thanks

Ben
benhall
 
Posts: 69
Joined: Fri Dec 14, 2007 11:15 am


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests