Searching in multiple fields

[softhead]

I have a loan form where there are five separate fields to fill in the loan item information (because they can loan up to 5 itmes). I would like to be able to show the history of the item by doing a search and then displaying it as a columnar report, but how would i go about searching for that one item so that it would find all the records with the item in any one of the five fields?

Thanks,

Anita

[Caren Pelletier]

Hi Anita,

Try making a calculated field that is a concatenation of the other five fields (with spaces in between). For example:

field1 & " " & field2 & " " & field3 etc.

Then do your search within this field and it should give you a resulting found set that contains any record that has the requested text in any of the five fields.

Hope this helps!

------------------

Caren Pelletier

HighSoft, Inc.