Help with a relationship, and PatternCount Field or something like.....
I have 2 tables i'm working with in this question. T15_Products, and EVO_vs_United. At the moment they have no relationship in the graph. What I would like to achieve is a field that if the value of T15_Products::manufactures_part_number is somewhere in EVO_vs_United::Evo_description or EVO_vs_United::United_description it displays T15_Products::manufactures_part_number.
EVO_vs_United::Evo_description and EVO_vs_United::United_description only contain a maximum of about 125 chars and are on 1 line of text.