Two tables one header, one lines need lines refer to header
(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?