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.