Hi David, I thought I'd done this as you suggested but I'm getting some unexpected results in my pop up value list...
On a hidden layout I have CodeNames field (text, indexed) containing: 1A 2A 3A 4A 5A Also on this layout I have LongNames field (text, indexed) containing: Alex Stanton Andrew Nicholls Anne Marie William Anthony Williams Ben Roome In my main visible layout I have "Operator" (text) field using value list "Ops" which uses values from CodeNames first, and values from LongNames second. The list is sorted by the second field. When selecting the pop up it's displaying the following: 1A 2A 3A 4A 5A Alex Stanton 1A 2A 3A 4A 5A Andrew Nicholls 1A 2A 3A 4A 5A Anne Marie William 1A 2A 3A 4A 5A Anthony Williams 1A 2A 3A 4A 5A Ben Roome And when selecting one of these values, for instance: 1A 2A 3A 4A 5A Alex Stanton The field displays 1A 2A 3A 4A 5A The desired state I want is for the user to select "Operator" and for the popup to show: 1A Alex Stanton 2A Andrew Nicholls 3A Anne Marie William 4A Anthony Williams 5A Ben Roome And when 1A Alex Stanton is selected for instance in "Operator" to display 1A. Where am I going wrong? TIA Dave ------------------------------ > > I assume the Long name and employee code number are field values in a record > and > you are choosing the code number. The value list should then be the the values > of the code number field and an option in setting up such a value list is that > you can show values from a second field (long name) also. This list can be > sorted on the second field. So what you will see in the pop-up is a list of > "code > number" <space> "long name" and when you select the a value the code number is > dropped in the field. > > Be warned - if the code numbers are not unique (key field) then results may > not > be what you expect. -- To unsubscribe: send an email to <[EMAIL PROTECTED]> FMPexperts is hosted by Ironclad Networks <http://www.ironclad.net.au/>
