When I do an update on the table I need to automatically increment one of the fields something like so:
Value1 = 'NewValue'
Value2 = Value2 + 1
Is there a way to do this somehow?
Value2 is used kind of like a version number! Don't ask!