CLOSE TABLES all CLEAR CREATE TABLE c:\yy (fld1 c(10), fld2 c(10)) FOR ia=1 TO 100 INSERT INTO yy VALUES (PADL(ia,10,"0"), "record"+TRANSFORM(ia)) ENDFOR INDEX on fld1 TAG cdxindex INDEX on fld1 TO c:\yy1.idx USE * choose .f./.t. here to see the difference IF .f. && both cdx, and idx indexes available USE c:\yy INDEX c:\yy1 USE (DBF()) IN 0 AGAIN ALIAS _1 else && only cdx index available USE c:\yy USE (DBF()) IN 0 AGAIN ALIAS _1 endif