| Author |
Message |
icecurtain
Joined: 18 Jan 2010 Posts: 9
|
Posted: Mon Dec 03, 2012 6:27 pm Post subject: Two tables one header, one lines need lines refer to header |
|
|
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? |
|
| Back to top |
|
 |
icecurtain
Joined: 18 Jan 2010 Posts: 9
|
Posted: Tue Dec 04, 2012 10:10 am Post subject: |
|
|
| Found the answer, it is to use between 10 and 10 not 1 and 10 sorted, a night sleep clears the mind. |
|
| Back to top |
|
 |
|
|
All times are GMT + 1 Hour
|
| Page 1 of 1 |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group