Question
Change Field Value after Inserting Record
Hello,
Does anyone have any suggestions on how I can accomplish this?
I've got a master/detail page bound to a table called "requests". On the detail page, I have a form button that when clicked, "converts" the request to a project (creates a new record in the "projects" table). To do that, I created a form with the Insert Record server behavior. This works well and copies over the values from the "request" record fields.
What I'd like to be able to do, is after the project record is created, I'd like the value in the [status] field of the "requests" table to change to "Project Created". Both tables contain the [request_id] field.
Any suggestions? Thanks for your help.
Does anyone have any suggestions on how I can accomplish this?
I've got a master/detail page bound to a table called "requests". On the detail page, I have a form button that when clicked, "converts" the request to a project (creates a new record in the "projects" table). To do that, I created a form with the Insert Record server behavior. This works well and copies over the values from the "request" record fields.
What I'd like to be able to do, is after the project record is created, I'd like the value in the [status] field of the "requests" table to change to "Project Created". Both tables contain the [request_id] field.
Any suggestions? Thanks for your help.
