I have VFP 7/8/9 installed in my machine. The situation is that when I do a

select * from <table>

the result query is using the source table index file. If I go to table..Properties...in the menu, I can see the indexes of the source table and if I change the index the result query is showing the data indexed. Same happens if I used into a cursor in VFP 7/8/9 version.

What is going on?