Hello David, Tuesday, April 19, 2005, 11:47:59 PM, you wrote:
> Hi all, > [FMP 6] > I have a value list that contains a list of long names ; David Anthony > Leicester, John Fred Smith, for instance that�s selected from a pop up. > What I�d like to happen is when a long name is selected that the actual > data displayed in the field is the �shortened version�, like an employee code > number. > Is there a way to do this without writing lengthy Case or If statements > for each name/value list? I suppose it would have to be something on the line > of a relationship between Long and Short value lists, but not sure how to go > about it. > Any ideas or alternatives? > TIA > Regards > 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. -- David -- To unsubscribe: send an email to <[EMAIL PROTECTED]> FMPexperts is hosted by Ironclad Networks <http://www.ironclad.net.au/>
