Have you tried SQL menus?
ie. SELECT col1 + ' (' + col2 + ')', col3
Stephen
________________________________
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Cupp, Michael E Jr. CTR USAF
AFRL/SNOD
Sent: Tuesday, April 24, 2007 2:29 PM
To: [email protected]
Subject: Question on Menus
Importance: High
**
I would like to create a menu so that when I use it for a list to
populate a field I see something like this:
Menu based on table x
col1
col2
col3
col4
...
Menu would display
col1 (col2)
and would return col3
I can make it display col1 and return col3, but when I add col2 to the
menu, I get submenus, and I don't want this.
Any ideas?
__20060125_______________________This posting was submitted with HTML in
it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"