>Does anybody have a form that does SEEKs on multiple fields at once? I want to be able to lookup a record in a database based upon criteria from multiple input fields. But sometimes the fields that get used for the SEEKs are left blank and would not be part of the search critieria in those cases.
>
>I don't want to use LOCATE because it is not as efficient nor as quick as SEEK and the database file I am searching on is huge. So I need to OPTIMIZE the search as much as possible.
>
>Just trying to save myself some reinventing the wheel time. Thanks.

Steve,

LOCATE with optimization conditions can be nearly as fast as SEEK (not quite but pretty close). When the issue is a single locate to find a matching record the difference in performance between a fully optimized locate and a seek is nearly immeasurable. Besides, LOCATE cna do things that SEEK cannot do, like matching on multiple fields where some of them may not be ivolved in teh current search.