>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only