Hello everyone,

Dreamweaver has a practical behaviour that allows to insert records into a single table. Per their documentation, the limitation is in that it can only insert records into ONE single table.

I am trying to get some help with inserting into multiple tables at the same time on submit: I have a summary table and detail table with a one-to-many relationship. I am using MS Access as well as ASP-Javascript as the server language.

Any help is appreciated.

Thanks,

Emmanuel

There is a tutorial from the <b>Dr.Dev</b> website that should give you some direction on how to do that. It is in VBScript, so may have to do some tinkering for JavaScript, but it should give you the conceptual method at least:

<b>INSERT, UPDATE & DELETE records in multiple tables</b>
drdev.net/article01.htm

<b>Connman21</b>
www.conncreativemedia.com
<b>DEVELOPMENT SETUP</b>
DW MX Studio
Web Server: IIS5
DB: Access2000/SQL2000
OS: XP Pro
Language: ASP/VB