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

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

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.

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.

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.