Assuring all parents get children
dlutz
Posts: 10
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.
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.
Comments
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