AnsweredAssumed Answered

Matching Data From One Field to Another Field In Different Table

Question asked by ezellkendrick on Nov 4, 2014
Latest reply on Nov 4, 2014 by 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.

 

 

Outcomes