I have one parent table and two children. I want to create one table with the fields from all three (for a report). Is there an easy way to do this without hardcoding the fieldnames?

For example,

Parent table = table1
1st child = table2
2nd child = table3

use table1 order tag site
use table2 in 0 order tag site
use table3 in 0 order tag site

sele table1
set relation to site into table2
set relation to site into table3 additive
set skip to table3

Instead, I want one cursor with the fields for all three so I can use it in a report easier.