Thad, Thank you! Unfortunately, this sets the Database ID number, which I have tried and doesn't seem to work with the Advanced Change Field properties. I appreciate the assistance! Shawn Stonequist EMNS, Inc.
_____ From: Thad Esser [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 3:35 PM Subject: Re: Advanced Change Fields ** Have you tired the $FIELDID$ keyword in your Set Fields? Current Table = $FIELDID$ Thad Esser Remedy Developer "Argue for your limitations, and sure enough, they're yours."-- Richard Bach "Shawn Stonequist" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[EMAIL PROTECTED]> 04/12/2007 12:15 PM Please respond to [EMAIL PROTECTED] To [EMAIL PROTECTED] cc Subject Advanced Change Fields ** Greetings list! I've got a few table fields on a form and would like to refresh the last one touched when a menu option is selected. I'm trying to use the Advanced properties of the Change Field Action so I only need 1 (I already have other workflow that has to run anyway, so I added a Set Fields that sets the value of "Current Table" as well). It appears that my Set Fields that states what the current table is isn't correct- I've tried the following Current Table = "$Table Name$" Current Table = "$Table ID$" Current Table = "Table Name" Current Table = "Table ID" Current Table = $Table Name$ I can see that Current Table field is being set properly for each of the above options that I tried. Unfortunately, when I review the workflow logs, it appears that the System doesn't like any of these and states that "***** No such field on schema" No Run If No Execute On Menu/Row Choice is selected My Advanced Change Field simply Reads: Field Name: $Current Table$ Refresh Table Field is checked Does anyone know why I'm having issues? Thanks! Shawn Stonequist EMNS, Inc __20060125_______________________This posting was submitted with HTML in it___ ***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
