I am fairly new to filemaker and i have a script that is giving me fits. I think it is simple for an advanced user so I apologize ahead of time if it seems minuscule.
I am trying to have a script that searches2 fields and then changes the value of another field. The problem I am having is that when it searches my second field it is looking for the exact words.
Bascially where is says Product I need it to search every thing in the product field for ADDVANT which is the first set of charectors in some of the fields the complete field content would look like this.
Here is my if statement.
ADDVANT 20 PT2
ADDVANT 20 P2