Jaya,
If the solution works for you bar the missing TR value, then force a commit down to the database on form 1 before you do the set fields in form 2. You can do this with an Application-Release-Pending command run before the push fields (Phase 2) operation. Alternatively do the submit to form 2 with an active link firing after modify. Or if the entry in form 2 already exists then get an after modify active link to "touch" the record to cause the set fields action to fire. Brian Bishop _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: 16 March 2007 11:46 To: arslist@ARSLIST.ORG Subject: Re: Diary Field Issue Hmm .. in that case I wonder if a direct SQL to update the diary field contents would yield better results? Want to give that a shot? Joe ----- Original Message ---- From: jaya munjal <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Friday, March 16, 2007 3:14:38 AM Subject: Re: Diary Field Issue ** Hi Joe Thanks for your suggestion. I tried this, but the set field only gets the DB Value and not the TR.Value of the dairy field, as the data is still not updated in the database. Secondly the issue comes with the value of Time stamp. Please let me know if you have any other work around. Many Thanks for your help Regards Jaya Joe DeSouza <[EMAIL PROTECTED]> wrote: Jaya, Approach your problem from a slightly different angle... Instead of doing a Push Field from the main form to form 2 which is working as designed by copying only the TR value of the Diary field, do a Set Field filter on form 2, on 'Submit'. Set fields will copy the whole shebang TR + DB value... Hope this helps. Joe D'Souza ----- Original Message ---- From: jaya munjal <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Thursday, March 15, 2007 2:26:36 AM Subject: Diary Field Issue ** Hi Listerner I am facing a problem while working with Diary Fields. Below is the scenario that I want to implement When ever the status is set to Closed on Form 1, it pushes the data to Form 2. There is a work log field( Diary Field) that also needs to be pushed to Form 2( Dairy Field). Issue As per design only current TR.Value of Diary field is being pushed. I require the complete worklog to be pushed. Any suggestions or workaround would highly be appreciated. Thanks Jaya _____ Need Mail bonding? Go to the Yahoo! <http://answers.yahoo.com/dir/index;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOAR fcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=ask&sid=39654 6091> Mail Q&A for great <http://answers.yahoo.com/dir/index;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOAR fcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=ask&sid=39654 6091> tips from Yahoo! Answers users. __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"