Sample data: 0-9

Previous  Top  Next

 

0-to-many relationship

Valid for: text / number / integer / GUID

Select: Referential Link | select master table and column

 

Takes a random value from the master table as the new value in the detail table.

 

1-to-1 relationship

Valid for: text / number / integer / GUID

 

To generate a strict 1-to-1 relationship between two tables, you need to generate the same number of rows, but also make sure to pick unique values from one table to generate the relationship.

 

This can be done in two ways, either select "For each in..." under the rows-method and generate "between 1 and 1 rows" for the current table.

 

Alternatively, create a "table lookup" and set it to "unique", select "All rows from lookup", this will create the same number of rows as in the lookup-table.

 

Make sure to select a column from the detail table that either has a value from the "master" or "from lookup" to generate the link itself.

 

1-to-many relationship

Valid for: text / number / integer / GUID

 

To generate at least 1 detail row for each master row, you can use the "For each in..." method of filling the detail table and enter "between 1 and (larger number) rows" for the current table.

 

Make sure to select a column from the detail table that has a value from the "master" to generate the link itself.