Change Field Value after Inserting Record

[WPW07]

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.

[Newsgroup_User]

WPW07 wrote:
> 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.

Use the Update Record server behavior to update the record.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/