AnsweredAssumed Answered

Joining Fields together

Question asked by PeterDowns on Apr 4, 2011
Latest reply on Dec 2, 2011 by AngusWalker


Joining Fields together



I come from an access background so I am trying to get my head around a few differences.

My problem is I have a table of users with for example a UserID field / First Name / Last name / location etc

I want to create a popup menu that uses the userID as the reference field but displays the full name of the user ie First and last name in the drop down. So I have tried a value list but am only able to pick 2 fields USerID + first name and can't edit to do more. I can do it several different ways in access but i can't find anything in knowledge base how to do it in FMP.

Thanks in advance