Hello David, Monday, April 25, 2005, 9:55:42 PM, you wrote:
> 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 The display you are getting for the pop-up indicates that the Codenames field contains the same data across all five records listed. To achieve the proper output you need each Codename and the corresponding longname in separate records. The final output looks like the sort of thing you would get by multiple selection of values using a checkbox, i.e, values separated by carriage returns. -- David -- To unsubscribe: send an email to <[EMAIL PROTECTED]> FMPexperts is hosted by Ironclad Networks <http://www.ironclad.net.au/>
