>>>>>TIA
>>>>>Cetin
>>>>
>>>>Curious, how would you have it work? IOW< what should the result be? Two realted cursors?
>>>
>>>Yeah n related cursors as one.
>>
>>As one cursor? As in denormalized?
>>
>>I still don't think I understand...
>>
>>>IOW similar to what I get if I bind it to a MSHFlex control :) Actually I only want it as readonly and don't want to build corresponding SQL in VFP too (shape syntax).
>>>Currently I have to do a series of looping to get where I'm clicking on a band of Hflex.
>>
>>Is this the Flexgrid? I haven't used it...
>
>Erik,
>After all those years I still can't understand what normalized-denormalized means :) So I cannot answer that part.
>It's hierarchical flexgrid. Like grid version of treeview.

Ok, but it doesn't bind to a VFP cursor does it?

My point is that there is no single cursor representation of a hierarchical recordset. You could, however, convert the recordset into two or more cursors that could be related with PK/FK fields...