>Hi Mark,
>
>I have done similar things before. Typically, what I do is create a common structure for the report, either through creating a cursor wiuth CREATE CURSOR and manually populated the cursor records with data from the two *or more* source tables, or combining the two tables wia a SELECT-SQL...UNION statement as in:
>
>
>SELECT name AS Field1, address AS Field2 FROM table1 ;
> UNION ;
> (SELECT city AS Field1, state AS Field2 FROM table2) ;
> INTO CURSOR curTmp
>
>
>The one hook is that the field types you are combining into a single column must be the same. Once complete, run the report against the cursor.
>
>HTH,
>Phil
>
>>I need to print (preview) a report from two tables. Both have a different structure. It's like to have a report with two detail bands.
>>Thanks Mark
Or you could create one table with all distinct fields that are in both tables, rather than renaming fields from the second cursor to match the first, then append from each individual table... You might also want to add a control column to identify the detail type being shown so the different header labels can use the "Print When" feature...