Michael,
Set the string in col1 to be "col1 (col2)".
Then the menu only needs to show "col1" to get the string "col1 (col2)".
OR. (and I like this next option just slightly worst then having a root canal)
Use an SQL menu to concatenate the col1 and col2 fields with
parenthesis where you want them instead of using a "Search" menu.
--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap.... Pick two.
On 4/24/07, Cupp, Michael E Jr. CTR USAF AFRL/SNOD
<[EMAIL PROTECTED]> wrote:
**
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"
