8 Replies Latest reply: May 15, 2012 5:41 PM by Justin Martin RSS

    Set variable wtih specific value



      This might be much simpler than i'm making it out to be, but is there a way to set a variable to a value based on another field value?  For example, I have a Week Number variable set to 5, hard-coded, and I want to set a Week End Date variable from the table where Week Number = 5.  Basically look up this value in a table according to this other value and store the result in a variable.  There would always be one value returned from this lookup.  Any ideas?