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"
