I have a parts table. In it there are two fields that have string info (Customer and CPN). For instance:
Parts Table Example:
PartNo
Customer
CPN
1678
Yen/Stick/Pearson
Yen: 2321*Stick: 52344J/45*Pearson: Hy45
1679
Carson
Cy8911
1680
1681
Harry's
In the example...