Sample data: O
|Previous Top Next|
Customer orders with several order lines are a typical case for databases. The example can be expanded to "shopping cart with several items" and many other types of data. Below is a way to generate data for such a case. The Sample Video has a
Generating these is a two-step process:
Generate fixed number or random numbers of rows, eg: 2500.
ORDERS table example
Order Lines table
Generate between 1 and 20 rows "for each in" the orders table. Select the OrderLines table and for Rows, select For each in... - then select the "master item" from the list: Orders. Enter values for "between 1 and 20" rows.
When generating data for the OrderLines table, you can select values from the "master" item, if required.
ORDERLINES table example