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 ____________________________________________________________________________________ Expecting? Get great news right away with email Auto-Check. Try the Yahoo! Mail Beta. http://advision.webevents.yahoo.com/mailbeta/newmail_tools.html _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"