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'
If not, how do you find the SQL values for your forms? thanks Anthony -----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"
