>which index tags do you have for yoru table x2 ? i have no index i use index only via code
>index on f1 tag f1...f1 unique
> INDEX on f4 TO kk

BTW, as you are not too firm on some vfp points, perhaps you should reread the parts on what behaviour "unique" causes if used in an index. In most applications "candidate" or "primary" are needed to *enforce* uniqueness of the entry in the table. "Unique" is often helpful as a fast way to walk distinct entries (a fast way to Group By), which admittedly is the use here.

And unless the x2 table gets recreated very often, define the indices once as a structural index AND LET THEM STAY ON THE DISK.

regards

thomas