Change Field Value After Inserting Record -
01-04-2008
, 07:51 AM
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. |