Matching Data From One Field to Another Field In Different Table
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.
Set Variable $$Name in Table 1
If (Table2::Name2 = $$Name)
Perform Script "ABC"
However, the above example doesn't work. I have tried using GetField, PatternCount, Value etc.
Your help is appreciated.