General search button

[vilem]

Hi,

I am pretty new to FM, I am a multimedia designer who's used to work with dreamweaver, director etc but not FM.

Here's my question:

I have a database. There is about 10-12 different fields in it.

I wan to make a search button that will search throughout ALL these fields.

Is it possible?

If so can someone tip me in, cause I am at a lost right now.

Please keep in mind that I started working with FM 4 days ago

So explain it to me like you would explain a 7 year old

Thanks

Vilem

[QuinTech]

Hi, vilem. You can make a calc field that concatenates all of them, like so:

NameOfField01 & "" &

NameOfField02 & "" &

NameOfField03 & "" &

...

NameOfField12

Then searching on that field will search all those fields. It's not necessarily the BEST way of doing this, but it will get the job done.

HTH,

Jerry

[transpower]

Make a repeating field which contains your fields, one field per repetition. Then do a find using the repetition field; FileMaker will search all the repetitions for your request.

[Ender]

How's that supposed to work transpower? Only use repeating fields for data, or have some script update the repeating field with the contents of other various fields? This makes no sense.

[-Queue-]

I think he means use a calculated repeating field that uses a particular field for each repetition. Choose( index - 1, field1, field2, field3, field4, ... ) where index is a repeating number field with the number of necessary repetitions, with 1 in the first rep, 2 in the second, etc.