Hello,

I have run into what seems to be a simple task on the surface, but requires some real "Out of the Box" thinking.  We have a form that is suppose to update a database.  On this form we are pulling the current values of the record, and we also have "New Value" fields for updating a value in the database.  Where this becomes tricky is you only want to update one field, rather than the entire row at one time.  Otherwise the system passes blank values to the DB.  My question is, how do you set up a for each value activity having the Retrieve Forms Content Tokens placed in as the current value, then for the system to know which of the new values to update.

The way the Update Data activity is written, you have to have a value for each field in the database, because any could be updated.  Has anyone accomplished this before?  A few of us are scratching our heads.