Hello, I would like to have a field that the user can type into (this will do the search), that will be related to all fields. In other applications, I would create a field and label it "name="_allSearch".

The reason for this request, I want the user to have the option of going to fields that are label for the search request (::search:: First Name,

::search:: Date Submitted) OR just have a generic field (search Any Field) that they type the request, and all fields are searched to return possible results.

Boy- i'm sure i typed this more complicated than it needed to be.

BTW: here's a page i created that shows what i want.

http://www.pdawax.com/TrashMe/SafeWaySearch.html

Paul

I can see a couple of ways of achieving this:

1. You can create a calculated field which concatenates all fields that can be searched on. You then search on this field.

2. You use some Javascript to complete a form which has a list of all of the field names to be search-on.

Good Luck

Garry

onecolor:

We did exactly what garry described-#1 (calculation called MEGAFIELD) and so far it works great. We were worried about response time but have not noticied any delays on our relatively small database. We left it unstored.

BTW, let me know if you want to see... I can send you the URL.

Sktajiri, thanks for your reply. Worked perfect. Here's what I used:

date submitted & " " & id number & " " & description & " " & note

Paul