What I would do is setup a hidden table on the form and use an external qual to populate the table with the email addresses. Then you can use a guide to walk the table and append a field with the column and you'd have as many emails as you need.
------------- Dylan Wheeler Production Control Analyst Principal IT Operations Downey Savings & Loan Association, F.A. Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer Sent: Thursday, October 18, 2007 9:59 AM To: [email protected] Subject: Active Link Set Fields - need multiples to append ** Hi Everyone, Sometimes I get all caught up in 'the Remedy can do anything' scenario and agree to do things that may have limitations. This one seemed harmless, but alas I've been caught in the typical 'sales' syndrome. I need to populate email addresses that are of a certain type (Install Contact) into a field on the Task form (finding them is no problem). Created a field on the form with plenty of space since there could be 2-3 email addresses to set in that field. Went to create the Active Link on Display to set the email addresses on the Task when it is opened so that the automated email that may be initiated if certain criteria is met will use those email addresses. The issue I am having is setting more than one email address to that field. The criteria for finding the email addresses is that all these people are related to one company (specified on the Task via field contents). The A/L really wants me to choose one or none or give an error message. I need it to take however many are found and put a comma between them and put them all in the field. I thought I'd be able to append or something like that. I suspect I may be able to do this via sql but I'm not sure what the statement would be. But all suggestions are welcome ! Thanks for your help in advance, Susan Susan Palmer ShopperTrak Server ARS 7.0.1P2 on Windows 2003 Oracle 10g Admin/User 7.0.1P3 __20060125_______________________This posting was submitted with HTML in it___ This message and any attachments are for the intended recipient(s) only and may contain privileged, confidential and/or proprietary information about Downey Savings or its customers, which Downey Savings does not intend to disclose to the public. If you received this message by mistake, please notify the sender by reply e-mail and delete the message and attachments. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
