>thanks, I thought I saw codes in the past to do that with sql statement? but anyway, thanks.
>sherry
If SQL is a must :
select padr(transform(myField1),40),padl(recno(),5,'0')+'_1' ;
from myTable ;
union ;
select padr(transform(myField2),40),padl(recno(),5,'0')+'_2' ;
from myTable ;
order by 2 ;
into cursor crsCombo
Cetin