Hi Afier ---

My we are busy today, eh? :-)

Anyway, they are three different animals. Lookup() returns the value of a specific field based on a search criteria (yet moves the record pointer). I would guess that it operates similar to LOCATE internally (sometimes optimized depending on indexes). LOCATE is a general "find it" command that is useful when you cannot do a direct SEEK on a value. SEEK is the preferred *if* your searches are limited to index expressions.

So, in summary, there is no *best* --- each has nuances in why you would use it.

>
>We are using Visual FoxPro 5.0 and we are making a framework. If we want to locate a record we can use Lookup(), Seek and Locate. We would like to know if there is an advantage of using Lookup() above Seek or Locate. Thank you for your time.
>