>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.
Hmmm, if you don't have any duplicate fieldnames, you could select each table and do an afields(la1), afields(la2),afields(la3), then combine them and create a cursor. If you do have duplicates, you could just delete the dupnames as a part of the process...
John Harvey
Shelbynet.com
"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright