1 Reply Latest reply on Nov 4, 2014 6:15 PM by ezellkendrick

    Matching Data From One Field to Another Field In Different Table

    ezellkendrick

      Title

      Matching Data From One Field to Another Field In Different Table

      Post

      Hello,

      I am having what I consider a vary simple issue that I can't resolve.

      I have Field (Name1) in Table 1 and I would like to compare the text in that Field from one record to Field (Name2) in Table 2 to find the matching name in that table, which can be on one or several records, before my script proceeds to the next step.

      Example:

      Set Variable $$Name in Table 1

      If (Table2::Name2 = $$Name)

      Perform Script "ABC"

      End If

      However, the above example doesn't work. I have tried using GetField, PatternCount, Value etc. 

      Your help is appreciated.