October 22, 200421 yr 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
October 22, 200421 yr You will want to make a new field concatenating the two fields. Something like this: c_Combined_PartNos
October 22, 200421 yr 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.
Create an account or sign in to comment