>Hi, I'm new to VFP (3.0b) and am hoping you will be able to help me with some ideas on the best way (user-interface wise) to lookup an indivual in a database. I have a database of 12,000 Alumni, and users need to lookup Alumni from the database useing one of several search criteria (lname, grad date, City, ID#, Company, etc). The initial search could produce multiple individuals (ex. lname="Brown" could produce 40+ Alumni) from which I would like the user to be able to select one. I would then display full Alumni information for the selected Alumni.
> My thought was to have a listbox holding the initial search criteria (lname, grad date, City, ID#, Company, etc.) and a textbox for the user to enter (for instance) the last name. When the user clicks on a FIND button, I would search the database, fill an array with the results, and bring up another listbox based on the array. The user would make his/her final selection here.
> Does this seem like the 'right' way to do it? Any other thoughts? Thanks in advance,
>
>Dave DeHaan

Dave,

There are many, many ways to find a record. Each one as individual as the programmer who created it. The 'best' way is really a matter of personal preference.

One way that I've used lately seems to work pretty well.

Using the same form that you use for data entry, create a 'search mode' so that the user can enter information into any of the available fields. When they press 'OK' (or 'GO' or whatever), a filter is set on the file to show only those records that contain the information entered. In your case, LName, City, etc.

Since this is a relatively small table, the filter should not slow the system significantly.

My users seem to like this method. Perhaps yours will too.