Figure 0.25 Expand Selected Table to add a Parent's Children
The Expand Selected Table dialog is accessed from the Edit Insert Data Scenario dialog. Use this to select a parent table, and let TurboData automatically add all of it's child tables to the list of tables to be used for data generation in the Insert Data Scenario.
For example, this dialog can be used with the sample Customer Order database to add all the child tables for the Customer table. TurboData would traverse the database to find all the tables with foreign keys pointing to the Customer table, and automatically add the Order and Order Line tables to the list, with their foreign keys resolved correctly to the selected parent Customer table.
You choose how many levels of children that TurboData should expand to. The parent table is level 1, it's immediate children are level 2, it's grandchildren are level 3 and so on. The parent (level 1) will already have it's start and end range set in the previous dialog. Use the grid to enter the start and end ranges for each child level. TurboData will deduce the quantities based on the start and end ranges for each level, and the parent levels.
Helpful hint: After expanding a table, use the Set Foreign Keys dialog to view and fine tune the parent child relationships for the expanded tables.
