Can I generate two sets of data into the same table?

[screek]

Is it possible to generate two (or more) sets of data into the same table?

For example, I have generated a table of "Persons" and a table of "Organisations". Now I want to generate a table of "Addresses" which sources data from both the "Persons" and the "Organisations" tables (so that there is one address record for every person and every organisation)

Is this possible?

I tried about setting a a view across both parent tables and sourcing from that but the generation does not seem to occur in the right order and the Addresses tables ends up blank.

Thanks

[Brian Donahue]

Hi Stephen,

In the current version of Data Generator, you cannot generate the data in one column based upon SQL Data Generator-generated data in another column. It works only with existing data. This could be addressed in a future version.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521