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 <john.j.rei...@lmco.com>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: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
