Update Field Value In Other Table

I have two tables with the following details
table 1: Employees:
id (int)

name (varchar)

post_id (varchar)
Table 2: Posts
post_id (int)

Post_name (varchar)

Status (int)
I want on update the Employees table the Status field should be set "1" by changing the "post_id" field of same post_id in the Posts table.
What code should I use this in the events for updating the field. I used this code beforeedit event.
sql="UPDATE Posts SET Status='1' WHERE [b]Post_id= '"values("id")"'"

rs=CustomQuery(sql)

[/b]
It gives me code error
thanks in advance