What are the challenges you face when working across database platforms? Take the survey
Options

Two tables one header, one lines need lines refer to header

icecurtainicecurtain Posts: 15
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?

Comments

Sign In or Register to comment.