searching multiple fields from a single search field

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Database Search. 1 Search box, to search multiple db fields 4
Access Microsoft access database(creating a search engine form) 0
Search Function 1
Access Skip address field if previous field is blank 2
Query searching multiple fields 1
Searching Multiple Fields in a query 4
database search 1
Database search fields 1

Top