TBL Articles | | |
Id | Name | UnitPrice | Idwarehouse |
1 | arcticle01 | $1 | 1 |
2 | arcticle02 | $1 | 2 |
3 | arcticle03 | $1 | 3 |
4 | arcticle04 | $1 | 4 |
5 | arcticle05 | $1 | 5 |
to | to | to | to |
1113 | article1113 | $1 | 1113 |
Now I want to automatically insert through the slq the data in the tables below
50 articles in each CDStockRows
TBL CDStock (Id, NumberDoc, NameDocument, date, Total) |
TBL CDStockRows (Id, IdCDStock, RowNumber, IdArticle, AmountUnit, Price, TotalRow) |
TBL CDStock | | | |
Id | NumberDoc | Date | Total |
1 | 1 | 23-06-2017 | $50 |
TBL CDStockRows | | | | | |
Id | IdCDStock | RowNumber | IdArticle | AmountUnit | Price | TotalRow |
1 | 1 | 1 | A1 | 1 | $1 | $1 |
2 | 1 | 2 | A2 | 4 | $1 | $4 |
3 | 1 | 3 | A3 | 2 | $2 | $2 |
… | … | … | … | … | … | … |
50 | 1 | 50 | A50 | 3 | $1 | $3 |