>>Three tables contain the following data:
>>
>>Table 1: One transaction per record
>>Table 2: One date per record (child of transaction)
>>Table 3: One atribute per record (child of date)
>>
>>Table 1 records may have zero, one, or many children in Table 2
>>Table 2 records may have zero, one, or many children in Table 3
>>
>>Report should show all records from table 1, one per line
>>Under each item from table 1, report should show all its children from table 2, one per line
>>Under each item from table 2, report should show all its children from table 3, one per line
>>
>>The question: What is the easiest way to create the necesary cursor(s) to generate report
>>
>>TIA,
>>
>>Alex
>
>

>select   Table1.*, ;
>            Table2.*, ;
>            Table3.* ;
>       from Table1 ;
>               left join Table2 on (Table2.FK == Table1.PK );
>               left join Table3 on (Table3.FK == Table2.PK ) ;
>      order by Table1.Field1, Table2.Field2, Table3.Field3 ;
>      into cursor tmp
>

Thanks for the reply Gregory. I will try it, but I am not sure it will do what I need. I'll report back. Thanks.

Alex