Finding part nos

[IEW]

I have a "PartNO" field and an "AltPartNo" field. I want to search both at the same time by entering the part no in "PartNo" only and finding records that match either. TIA

Ivan

[Lee Smith]

You will want to make a new field concatenating the two fields.

Something like this:

c_Combined_PartNos

[transpower]

Or you could make a repeating field with two repetitions: the first repetition has PartNO and the second repetition has AltPartNO. A Find in a repeating field will find any record having the value in any repetition.