Value lists can have two columns. You need person ID as left column and person name as right column. You can configure the value list in a way that dropdown menues display only the name but store the ID.
That's great. Thanks very much for your help. I've tried this and it works great. Just one other questions though:
The field that the user now need to click on is the ID value of the person rather then the resolved name. While this works OK it is rather odd - to click on the ID and then have a list of names pop-up. Is there any way to have the value list of names pop-up when the user clicks on the displayed name and then have the ID field update when a selection is made? Or any other ingeniuos way to acheive the effect that I'm after. If not then don't worry.
Thanks again for your swift assistance!
Are you sure that your left column of the value list is the ID and the right is the name? If you check additionally the box 'show only second value' the names will be displayed for the user but the ID is stored invisibly.
this isn't completely true...
It depends from the way that you format the field holding the value list.
Drop-down list will show the first value, when exit the field.
Pop-up Menu will show the second value, when exit the field.
But both ways store ONLY the value of the first field.
You are right. This is because the difference between both is that you can edit the values of drop down list. So they have to show the left value which might be edited and overwritten with a new value which is not part of the value list.
this is also incorrect:
> you can edit the values of drop down list
It seems that you cannot edit a value of a pop-up menu, but it isn't the true.
Try to make a choose and, while the focus is still on that field, press CANC and paste the today date. ;)
FileMaker unfortunately is very inconsequent with value lists. Radio buttons for example are supposed to show only one value but with SHIFT you can add a second value. I consider the behaviour that you describe beeing buggy.
But it hasn't changed through 9 versions over some 20+ years! HaHa!
Hi Jens, Ray, Daniel, Scott
I have indeed got the Value List set up just as you describe and operation is also just as described i.e. if the field is a Drop-Down list then the First value is left on the page after making a choice, if the field is a Pop-Up Menu then it is the Second value that is displayed. How bizarre!
It has however allowed me to solve the problem by using a Pop-Up menu instead.
Thanks to all!