searching in more than one field

[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

[ZuperZZ]

Anita,

Try this:

1. Create:

-a global field (Gbl_Item this field will help you in the

[Vaughan]

It sounds to me that relational databases are needed here. One with the cient dtails, the other with the loan details. That way you can accomodate more than five loans easily.