Hi Quinn,

>Im using the seek command to seek a client name in a very large database with 1.7 m records. i have set the order to name2 which is the clients surname and then using the command SEEK locclient. locclient is a varible and the value is gotten from a textbox. I have tried several different syntax's but nothing will find the record. i am working in VFP 3.0 and i have tried go top.

Have you tried using the SEEK() function? It returns .T. if the seek works, .F. if it doesn't. It just saves you from having to do a FOUND() after the SEEK. But back to your question. Is the index expression locclient? The index expression has to match what you're seeking.

Have you tried doing a seek on ALLTRIM(locclient)?

Regrards,