Your Index expressions seems to be not Optimized. You should consider the Rushmore Technology of VFP or FP. I guarantee you 100% that using the same Index expressions, your system will not last especially if the table is growing rapidly.
Remember that VFP Database is not a High performance database.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."