I have a local view thats acting like a dog and I cant figure out why. The project is on a local c: drive and needs to access a table (which I placed into the project) on a server drive.

The local view I created is supposed to give users the ability to see all the names (which may repeat) of employee's transactions. The field is char 40; I created an index on the field (name) to help the query - vfp put the index on the server drive. The query takes several seconds to open and the table has only 3200 records. What am I doing wrong? Should I move the index locally?

TIA
CG