This topic is locked
[SOLVED]

 Setting One Previous Value To Other Field

1/29/2013 1:04:02 AM
ASPRunnerPro General questions
A
adnankmk author

I have one table in the database with the following fields.
table name: Information
fields:
id type(int)

Rec_From type(varchar)

Send To Dropbox which contains two values Sect1 and Sect2
I want, on updating the record, the previous value of "Send To" field should be assigned to "Rec_From" field. for example the value of "Send To" field is Sect1 and I want to update the field and change the "Send To" as Sect2 and after update the sect1 should be assigned to Rec_From. How should do this.
Thanks in advance

Sergey Kornilov admin 2/1/2013

BeforeEdit event:

values("Rec_From") = oldvalues("Send To")