>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
You should make sure that all indexes for a table are stored with the table in a compound index file (cdx).
Can you post the SQL that defines your view?
Erik Moore
Clientelligence