Searching more than one field at the same time

[ChangeAgent]

Does anybody know if in FMP 6 you can search more than one field at the same time?

I want to be able to search several fields in all records at the same time by entering the data ones in one field. In other words, there is data in field 1, 2, 3, and 4. I want to search all those fields at the same by entering a search word in a find field I than be able to search all those fields simultaneously.

And if possible can someone tell me how to do this?

Thanks

[Fitch]

One way to do it is to create a calculated field:

Field1 & " " & Field2 & " " & Field3 & " " & Field4

IOW, you're concatenating the 4 fields into one field, separated by spaces. Then you search the calc field rather than the originals.

Another option would be to make a script. You'd enter your search word in a global, then go to find mode and make new requests. Let me know if you need more detail.

[Ender]

I think I prefer the scripted method. That way you're not adding overhead with big indexed calc fields just for searching. This overhead may not be a big deal for just a few fields, but if the feature is extended to search a large set of fields, it could get ugly.

[ChangeAgent]

Thanks Fitch,

That works, but like Ender states it might create overhead. I am a novice in scripting, what would a script like that look like?

Thanks

[CobaltSky]

...what would a script like that look like?

Hi ChangeAgent,

Attached is a file (for FileMaker 6) containing an example of such a script. :wink2:

MultipleFieldFind.zip

[ChangeAgent]

CobaltSky greetings!

Thanks for the multiple fields find script, I adapted it and it works as one would wish it should. I am a very happy Scot today, all challenges solved and of to have my tea, and sending blessings to Melbourne (sorry whisky does not travel well via the whispering wires).

again thanking you