Jason, Thanks. That's what I thought I might need. --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Jason Miller Sent: Friday, October 09, 2009 5:42 PM To: [email protected] Subject: Re: Notifying with Join form info when the outer join right-hand side is created.
** Hi John, B will not "inform" A_B when a record is created. We recently had a similar scenario with a join of order details and line items. We wanted an email from the join to be sent when Help Desk ticket for a line item was completed. We did just what you mention. When the 'Status' is changed to Resolved on the Help Desk form (I am not saying if we used DB. or TR., hey it's Friday) it does a push field to the A_B form. All we are sending is "SendInstructions" to a DO field called CURRENT_COMMAND. There is a filter on the A_B join that will fire only if the CURRENT_COMMAND = "SendInstructions" HTH, Jason On Fri, Oct 9, 2009 at 7:55 AM, Reiser, John J <[email protected]<mailto:[email protected]>> wrote: ** Hello Listers, ARS7.1.00 Patch 004 MS SQL Server 2005 I have two forms that are joined (outer join) and I want to send a notification with .ARTask from the Join form. Example: Form A has a bunch of records. Form B gets a record created and is connected to Form A's record by the value selected during creation. The user wants to be notified with an .ARTask attachment for the joined records when the second record is created. Will a filter fire on the join A_B when the B part is created? Do I perform a PUSH Fields from B at create time to update a DO flag field on the Join form. I will have the join criteria at create time for Form B. Thanks, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me _Platinum Sponsor: [email protected]<mailto:[email protected]> ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
