Thanks for all the ideas; I am new to SQL menus.
Would it be Select (Field Name1) FROM (Form Name) WHERE entry_id = '1'
UNION SELECT (Field Name2) FROM (Form Name) WHERE entry_id = '1'
This is correct, except you will want to use '$1$' instead of '1'
If not, how do you find the SQL values for your forms?
thanks
You will need some kind of database tool like sql plus, oracle
developer, or toad. Those are Oracle, but all databases have some
kind of tool to access them. You will probably log in as
ARAdmin. You will see that Remedy has created a view of each form
using the form name but replacing the special characters with underscores.
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Julie Rockwood
Sent: Friday, December 08, 2006 11:40 AM
To: [email protected]
Subject: Re: dynamic drop downs
What great timing! I just had to do this earlier in the week. You
can use an sql menu with unions. This creates a list of 3 email
addresses from character fields in the parent record. Of course, if
it were from the current form, the where clauses would be WHERE
entry_id = '$1$'
SELECT customer_email
FROM Parent_Table WHERE entry_id = '$536870913$'
UNION SELECT assignee_email
FROM Parent_Table WHERE entry_id = '$536870913$'
UNION SELECT a2nd_tier_email
FROM Parent_Table WHERE entry_id = '$536870913$'
Let me know if this helps you.
Julie
At 09:09 AM 12/8/2006, you wrote:
>Hi all:
>
>Is it possible to dynamically create a dropdown list from a set fields
>action?
>
>I have several values calculated on loading of a new form.
>I then want to take those values (currently in char fields) and
>place them in 1 drop down for user selection.
>
>Any ideas?
>
>Thanks in advance
>anthony
>
>_______________________________________________________________________
________
>UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>ARSlist:"Where the Answers Are"
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
ARSlist:"Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
