I have an access 2002 database which includes 2 tables in particular. Work and Order. When a work request is received in the office it is entered in the Work table and has filed 'Status' that is set to I for identified.
When the work is to be come an order on a contractor a record is created in the Order Table which is linked to the Work Table by the 'Work No' Field which is the primary key of the Work Table.
The form to input the order has a command button which prints the order an closes the form. I would also like the command button to update the 'status' Field of the Work table to O for ordered when it is pressed.
The SQL code i have come up with looks something like this:
SET Work.Status = "O"
WHERE Work.WorkNo = Me.WorkNo
I'm not sure if this SQL is right and have no idea of how to actually implement it in the event procedure, can anybody help?
When the work is to be come an order on a contractor a record is created in the Order Table which is linked to the Work Table by the 'Work No' Field which is the primary key of the Work Table.
The form to input the order has a command button which prints the order an closes the form. I would also like the command button to update the 'status' Field of the Work table to O for ordered when it is pressed.
The SQL code i have come up with looks something like this:
SET Work.Status = "O"
WHERE Work.WorkNo = Me.WorkNo
I'm not sure if this SQL is right and have no idea of how to actually implement it in the event procedure, can anybody help?