If Table2 is a table and you have defined a Tag index,
VFP build a structural CDX index.
Everytime you use Table2 VFP open this index automatically.

Try this:

WAIT WINDOW STR(TAGNO('Table2'))
SELECT .....


You're right again, I didn't test it that good. Thank you for sharing, I wasn't aware of the lookup function in vfp, which is very handy.

Zakaria al Azhar