Insert into multiple tables

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

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

Great, thanks for that.

Chris