sai.htet

How to define a lookup with multiple fields?

Discussion created by sai.htet on Apr 11, 2012
Latest reply on Apr 12, 2012 by mark_scott

How do I define the relationship in "manage database" and write the correct scipt for lookup function if I have two tables like.

 

Table1

RAW DATA
futbal
fotbol

rugby

 

Table2

 

Raw Data1Raw Data2Correct Data
futbalfotbalfootball
rugbyruggbyrugby
frisbefrizbefrisbee

 

I want the script to read the table1, field and lookup the "Correct Data", then replace the rawdata in table1 with the correct data. I don't have a problem with the look up function if there is only 1 raw data field in table2, but when I add more raw data fields, i cant get look up function to work correctly.

Outcomes