[SOLVED]  update the current table field

This topic is locked

[SOLVED] update the current table field	12/11/2012 12:16:04 AM
ASPRunnerPro General questions
A adnankmk author I have one table which have three field named "Employee"; Emp_ID Posting_Date Transfer_Date. I want to add an event after record updated. My table value of Transfer_Date should become the value of Posting_Date. For example Posting_Date is 11/12/2011 and Transfer_Date = 10/07/2012. when I should update the page the event should assign the Transfer_Date to the field Posting_Date. Before event called. Emp_ID= 5 Posting_Date =11/12/2011 Transfer_Date = 10/07/2012 After the event called the result should be: Emp_ID= 5 Posting_Date =10/07/2012 Transfer_Date = current system date Thanks in advance


	Sergey Kornilov admin 12/14/2012
	Use BeforeEdit event and the following code: `values("Posting_Date") = values("Transfer_Date") values("Transfer_Date") = now()`