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

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

Post by WPW0 » Fri, 21 Dec 2007 23:19:52


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.