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
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