>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