I tried to out a criteria in a BAQ with criteria CONTAINS for the PArt# field. I got an error about indexing. Where do I go to Index the part number, desc, etc.
What table?
You might also try LIKE. You can use the Specified Constant value and enter %PHRASE% where PHRASE is your chunk of the part number you’re looking for. I don’t believe that requires it to be indexed.
This example would return any part numbers that had the characters ABC somewhere in the part number. If you wanted it to be like a Starts With, you could remove the first % sign. If you wanted it to be an Ends With, you could remove the last % sign. The percent signs mean that there can be anything before it or after it - depending on the location of the %.