Hi I'm fairly new to Data generator, so if this is a silly easy question - sorry for that, but I can't find an answer on my own.
(aim create 1,000 header rows, 10,000 line rows)
Two tables one header, one lines
Header has InvoNo, Number of lines easy to create (InvoNo 1 - 100000, Number lines always =10)
I need to create lines table data
So there are 10 created lines for each invono.
I Created header table first I can use InvoNo as foriegn key then repeat value between 1 and 10 it only create 5523 line rows.
How is it done?