Multiple field search capabilities...

[AspenArchive]

My goal is to be able to create a search or find request that search multiple fields within one layout for text entered once. If it were done without a script, one would enter text in one field and then extend the find to the next, and again to the next and so forth. I'm jumping the RTFA option and not having luck. I have Help, and I have Tutorials and neither are answering my question, so I looked to the trusty forum that's helped SO much.

Specific situation: I have a database for documenting around 200 concerts per season. Ten composer fields exist for the works performed within one performance/record and with a simple search of "Beethoven" in [Composer 1 Last Name] will bring up only all performances where a Beethoven piece was played first. I need our users to be able to find in one step/script every Beethoven piece performed within the season, which means it much search for "Beethoven" in [Composer 1 Last Name] as well as [Composer 2 Last Name] and so forth.

I'm sure this is too detailed but better to be overly detailed than insufficient.

I'm new at this and don't want to waste anyone's time so even just pointing me in the right direction would be VERY helpful and I can root through Help or the tutorials from there.

THANK YOU!!

SC

[aaa]

I will show how you can serch in 3 composer fields and you can understand for ten.

Create one global text field where you by value list or by hand put searching composer.Now script:

Enter Find mod

Set field[composer1,global]

New record request

Set field[composer2,global]

New record request

Set field[composer3,global]

Perform find

On this way you can do searching in ten fields.

[comment]

You should follow the same advice you have been given in your other thread. Bad data structure is not a theory - you're experiencing the consequences right now.

[AspenArchive]

Ahh - thank you for the advice. Unfortunately I am, within time constraints, "fixing" this database rather than redesigning it altogether.

However, after about 30 mins of fooling around with ScriptMaker here's what I came up with that worked (perhaps the script suggested here was for FMP 6), and it's probably a dirty way around something straightforward, but it works! (and I DID use "Composer Search" as a global field)

Enter Find Mode []

Set Field [Name of template::Composer 1; LeftWords (Name of template: Composer Search)

New Record/Request

Set Field [Name of template::Composer 2; ....

And so forth ending with

Perform Find []

Go to Layout [Program Page]

So for now I'm kind of screwed if the last name is two words - any further suggestions?

Thanks again!

SC

Edited August 26, 2005 by Guest