AnsweredAssumed Answered

Finding data within Field

Question asked by gsbilsky on Feb 10, 2010
Latest reply on Mar 20, 2012 by blewvelvet


Finding data within Field


I am trying to update TableOne::FieldTwo based on the following information.


TableOne::FieldOne has long string of data containing alpha, numeric, and/or dates.


TableTwo::FieldOne has short string of data matching within TableOne::FieldOne.

TableTwo::FieldTwo has information to be placed in TableOne::FieldTwo.


I have created the two table and can match if TableOne:FieldOne and TableTwo::FieldOne are exact matches.  But I only want partial matches.

How do I set the relationships?  How do I match partial information?


Should I set a Script and run it to up update TableOne::FieldTwo?


I am currently trying the following:


If ("*" & BankData::BankPayee & "*" = Payees_W_Cats::WherePayee; Payees_W_Cats::ReportingPayee ; "")


What am I doing wrong?  What should my relationships be?