3 FIELDS TO SEARCH

[KIM]

DEAR GURUS

IS IT POSSIBLE TO CREATE A FILTER WHICH SEARCHES MORE THAN 1 FIELD FOR RESULTS ? FOR EXAMPLE I WANT NAME1, NAME2, NAME3 AS MY THREE FIELDS WHICH CONTAIN DATA. ON THE SEARCH SCREEN IF SOMEONE ENTERS A NAME THEN THE PROGRAM WOULD SERCH ALL THREE COLUMNS AND THEN SELECT THOSE RESULTS. IS IT POSSIBLE ?

THANKS

KIM

[Mark]

Kim,
I only know of one way to do this and it involves writing your own filter form. See Example 5d at: http://www.aspdb.com/apps
I hope that helps.
Mark.


------------
KIM at 7/21/00 6:57:56 AM

DEAR GURUS

IS IT POSSIBLE TO CREATE A FILTER WHICH SEARCHES MORE THAN 1 FIELD FOR RESULTS ? FOR EXAMPLE I WANT NAME1, NAME2, NAME3 AS MY THREE FIELDS WHICH CONTAIN DATA. ON THE SEARCH SCREEN IF SOMEONE ENTERS A NAME THEN THE PROGRAM WOULD SERCH ALL THREE COLUMNS AND THEN SELECT THOSE RESULTS. IS IT POSSIBLE ?

THANKS

KIM