AnsweredAssumed Answered

Multi Key Field - "lookup" value?

Question asked by UhruSan on Apr 30, 2013
Latest reply on Apr 30, 2013 by philmodjunk


Multi Key Field - "lookup" value?


     I am trying to setup a relationship between two tables, where the field of table 1 holds a string composed of substrings ("aa ab ac ad"). Table 2 has keys for each of those substrings ("aa" = "123", "ab" = "456", "ac" = "789", "ad" = "098").

     As I am rather a newbie to FM, I am not sure how to accomplish this. I searched the forum and tried to define the field of table 1 as "lookup" field, but with no success.

     Any help is greatly appreciated!

     best regards,