Try to build an Index.

>Hi All,
>
>Here some problem that i have.
>I have table with lots of record...
>When i try to search some record with "LOCATE FOR" it's taking a time to C the result...
>
>Can you give me the best way what should i use for searching a record, the best and the fastest way...
>
>Which is the best Locate for or Seek or Else...
>Please tell me..
>
>Thanks,