Search All within 1(one) field

[onecolor]

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

[Garry Claridge]

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

[Steve T.]

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.

[Steve T.]

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

[onecolor]

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

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

Paul