>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.


Use views, then take a look at Query By Form (QBF) Builder at www.classycomponents.com.