I have 2 child tables with Foreign Keys from the same parent table all using the same unique 3-column key. I'm trying to generate different rows in Child1 and Child2, but have not been able to do so.
Parent Rows 600,000 (already generated)
Child Rows 300,000
I have changed the seed values several times, changed the Population method to Repeat Key Values at Random or All Key Values Unique but I still get almost 100% the same keys in the two Child tables when I would expect 50% overlap if it were truly random.
I also tried different row counts and seeds:
Child row counts 100: 6 are duplicates
Child row counts 100, changed seeds: 7 are duplicates
Child row counts 1,000: 561 are duplicates
Child row counts 1,000, changed seeds: 545 are duplicates
Child row counts 10,000: 9496 are duplicates
Child row counts 10,000, changed seeds: 10,000 are duplicates
Am I doing something wrong??