Forums

Insert into multiple tables

?
Guest 12 Mar, 2008
Hi,

Is it possible to modify the auto-generated code to insert the form data into two or more db tables?

I was hoping to send a few of the posted fields into a seperate table (within same db) with a second INSERT statement in the autogenerated code.

I tried making the two inserts with code that works directly in SQL but it didn't insert into either table through the form. The form did post the fields and upload a file though so it's must be the query breaking down.

Thanks

Chris
GreyHead 12 Mar, 2008
Hi Chris,

Yes ***If you know what you are doing*** you can edit the Autogenerated tab as much as you like. All that ChronoForms does is to execute the code in the tab.

Bob
?
Guest 12 Mar, 2008
Great, thanks for that.

Chris
This topic is locked and no more replies can be posted.