Hi,

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.

Please help

thanks
~Quinn