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
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