Search Every field in ever file in database

[RickBman]

ok... I need a way to search my entire database for keywords and have a report printed out of what records contain these keywords. Every field in every file needs to be searched for these keywords. I am running Filemaker 6 on my client machines with Filemaker Server 5.5, the database i need to search is about 30 files and at least one of the files has well over 100 fields that will need to be search in 400,000 records.

Is there any plugin that will do this or is this something that I will have to script, because it sounds like a really complicated thing to script.

[Ocean West]

create a field in each file that field is a concatenation with returns of every field in that file.

Then search on this field. -

[RickBman]

yeah... i was thinking about that but was hoping there was another way. I have done similar things in the past and it totally chokes up the server.

Has anyone used the Troi Scout plugin? it may do what I need to do, not absolutely sure though... it is Mac only but I have access to a couple macs so that may not be a problem.