Searching multiple fields & only 1 has to match

[meshcraft]

I apologize if this has been covered somewhere. (still looking) I need to do a search on multiple fields but only 1 of those fields has to match. In other words I have a setup of 8 slots for a payment history and payment date and I need to be able to search for any payments made within a range or specific date in any one or more of those slots.

I know you are wondering why are they not in a seperate table with each payment being a seperate record. There is a reason for this that is too complicated to explain. Other aspects of the database are in seperate tables but not this.

[meshcraft]

Actually just found the solution but if anyone has any other suggestions please post.

I found this solution from another post...

Enter find mode (if not already)

Set Field:A = Temp1

New Record/Request

Set Field:B = Temp1

New Record/Request

Set Field:C = Temp1

New Record/Request

Set Field:D = Temp1

etc etc.....

perform find