Guideline for searching multiple fields at once?

[Guest_imported]

I am quite new to FileMaker Pro, and I am currently using 3.0. I have an inventory database with numerous fields. I would like to give the user the ability to search all fields simultaneously by entering a keyword in one "Search All" field. As of yet, I have had no luck, as my scripting skills are quite weak. Can anyone give me a clear idea of what I need to do?

Thanks in advance. Susan.

 

[Schlogg]

You probably need two scripts and a layout showing all of the fields to be searched. The two scripts are
1. search every field
2. search only the field with the data in it.

Script1 (Outline only)
[Get the text to be found and put it in a field called FindIt]
Enter Find Mode
Set Field1, Findit
New Record Request [sounds crazy but that also starts a new Find request]
Set Field2, Findit
New Record Request
Set Field3, Findit
... and so on for all fields
Perform Find
[You have probably found this but, JIC, these multiple find requests act as though there is an 'OR' between them.]

Script2 (Outline only. Will only work properly if only one field is being searched.)
Enter find mode
Pause [to get user data]
Perform Find

HTH
Cheers,
Paul J.


Cheers,
Paul J.

 

[JeanW]

If the contents of the fields doesn't exceed 64.10³ characters you can make a 'search field' = calc =
concatenate all the fields where you want to search on.

Make a script to search on that field.

HTH

JW