Francisko,

Why are you trying to use a loop to do this. Try this

Select * ;
from orditems ;
into cursor tmporditems ;
where itemnumber in (select itemnum from orders where ordernum = customer.orders)

This should get you the items for each order for a specific customer.

HTH

Jeff

>I have a relation between customers,orders,orditems that work fine, but how can i do to fill a a cursor with the items of orditems that match the relation.
>if i do "do while !eof()" in orditems doesn't work. I loose the relation.
>
>EX:
>
>Peter Market
>Jhon Smith........Order11231
> Order11431...........Item111
> Item222
> Item333
>
>Create cursor ABC...
>DO WHILE ?????
> APPEND BLANK
> REPLA abc.item with orditems.item
>ENDDO