searching multiple fields from a single search field

M

mccloud

I have a website that has a single search field. In the page I created I have
a database results area that has 6 fields. I would like to have the search
field search several of the database fields and bring those records up.
Example... I might enter a partnumber in the search field and have it search
the partnumber field as well as the description field for matching data.

I,m using FP2003 and SQL2000.
 
S

Stefan B Rusynko

If using the DBRW just set your other fields (using the search field option) in More Options - Criteria




|I have a website that has a single search field. In the page I created I have
| a database results area that has 6 fields. I would like to have the search
| field search several of the database fields and bring those records up.
| Example... I might enter a partnumber in the search field and have it search
| the partnumber field as well as the description field for matching data.
|
| I,m using FP2003 and SQL2000.
 
Top