Believe me, I understand. Many times I find myself banging my head against the wall trying to do something the way I would in VFP. On my good days, when I back off for a while (or get some help from the marvelous folks here on the thread), it will occur to me that the way to think about it for .NET is quite different. Once I accept that, I can often find my way to a very different but effective type of solution in .NET. I lived through it when FoxPro went to Visual FoxPro so I expect I'll live through this, too. It takes a long time to change old habits and to learn to see things differently but it will come.

>Thanks for your replies
>
>I was trying to do this in code, with a VFP mindset, rather than having to go into the database and set up views.
>As well as a specific requirement, this is a lso a general question re th correct method in C# to do the
> sort of thing I have always being doin g in VFP. i.e Selecting out Cursors from Cursors etc.
>
>I think I will need to put more though into this
>Regards,
>Gerard
>
>
>
>>Hi Gerard,
>>Could you possibly accomplish what you are after by setting up views in your database and building business objects for the views? The other possibility might be to reference other business objects from within the primary business object.
>>Linda
>>
>>>Hi.
>>>Is there a way in .net (C#) to select to a temporary Cursor and then use this as the source
>>> of another select e.g.
>>>
>>>Select * ,.....from Tablea Into Table Temp1
>>>Select * from Temp1 into Table Temp2
>>>Select * from Temp2 into table Temp3...etc
>>>
>>>The above selects are just examples
>>>Each select is more complicated , with numerous fields and some
>>> of the selects are done for grouping purposes.
>>>
>>>Any help appreciated.
>>>regards,
>>>Gerard