Use record from one table to create new record in a different table?

Question

Hello,

I'm developing an application with a MySQL back-end. The
important tables are "requests" and "projects". I have a
master/detail page created that works well with request data. It
allows the user to review requests that are submitted. What I'd now
like to do is give the user the option of clicking a button on the
detail page that would create a new "project" record using all of
the request data.

Any suggestions on how this can be done?

Thanks for your help.

Newsgroup_User · Answer

WPW07 wrote:> What I'd now like to do is give the user the option ofclicking a button on the > detail page that would create a new "project" recordusing all of the request > data. Do it in exactly the same way as you would create an updatepage. In the detail page, draw everything into a form, and use an InsertRecord server behavior instead of an Update Record one.If you don't want anyone to be able to change the details,you can make the form fields read-only. Alternatively, display the detailsin HTML, but also put them in hidden form fields for the Insert RecordSB to pick up.-- David Powers, Adobe Community ExpertAuthor, "The Essential Guide to Dreamweaver CS3" (friends ofED)Author, "PHP Solutions" (friends of ED)http://foundationphp.com/

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.