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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
