| Thundaga 2004-08-26, 12:20 pm |
| I'm trying to get comfortable with Dreamweaver's command behavior for executing
an SQL insert, but I'm having a problem with figuring out how to do this.
I have two tables that have to be updated when a user inputs a form to the
form confirmation page. One table is for the customer's contact information,
the other is for the inquiry itself. I have a ContactID as a foreign key in
the Inquiry table because one customer could have many inquiries. How do I go
about inserting the ContactID that was just generated when the Contact table
was updated, into the Inquiry table? Both Primary keys are autonumbers.
Thanks,
Chad
|