Title
Joining Fields together
Post
Hi
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
Cheers
Peter
To show data from more than one field in the second column, define a calculation field in your users table that combines the data from these fields into a single block of text, then specify this field to be used in the second column of your value list.
Having used Access myself, I can predict a certain level of frustration for you in using Filemaker. It doesn't do things near the same way so it takes some getting used to before you can "switch gears" mentally to get things going smoothly for you. And FileMaker's value lists don't offer anything close to the nice combo box options you can use with Access.