In lieu of Alex's inclusion of the 'AND' function in the keyword search for the next release, is there a way the view screen for searching the database can be modified. I would like to keep the output structure the same (the complete record), but only show two or three fields (Name, City, Keyword) to have a search on so that the viewer does not have to be confused with all the record fields such ID, telephone number, etc.

Copy the html_record_form subroutine and paste it below the current one. You will now have two identical subroutines.

Rename the second one to

html_search_form

Delete all the fields you don't want users to be able to search on.

In the following subroutines:

html_view_search
html_veiw_failure
html_modify_search
html_delete_search

change references to

&html_record_form

to

&html_search_form



------------------
JPD

Thank you JP