Multiple search

[Fedoroff]

How can I do a search in 14 text fields (A1, A2, A3, etc.), within the same file, without doing 14 requests. The search should return all the records that has, at the least, one matching result. Now to make things more difficult, each field can contain from one to five words.

[birdman]

Create a calculation field that concatenates all of the text fields together. Create a Find script that takes the user to a special layout that has the new field on it and then carries out the find before returning to the original layout.