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