>Thanks for your answer.
>The problem is that i have navigation buttons to move the record pointer and takes to much time to do the select of the items of the order for the respective customer in a table with 200000 records.
>Making relation is faster, but i can't fill my cursor with the relation result.

Then your do while will have to do the work.

create cursor abc
select orders
do while orders.ordernum = customer.ordernum
select orderitems
**** Code here to build cursor abc
select orders
skip
enddo