AnsweredAssumed Answered

Simple(?) lookup question

Question asked by Corné on Mar 23, 2011
Latest reply on Mar 29, 2011 by philmodjunk


Simple(?) lookup question


Just when I think to understand the basics of FMP...

Hello all,

In a table, I like to lookup the first- and surname related to a global value gCustomerID. Preferably these first- and surnames concatenated to each other. Please advice me what method and calculation I should use? Thanks in advance!!

gCustomerID     First name     Surname

1 John Smith

2 Ric Faulkner

All the best,