I've created a database and I would like to change the structure of it to a normalized database to make it run more smoothly especially for reporting off of it. What I want to do is have a table that will keep track of all the transactions and a child table that will hold all of the line items of each transaction. In theory I know this is what I need to do. In practice I have no idea how to do it with Dreamweaver and ASP. Can anyone refer me to a resource that will help me insert multiple records into multiple tables? That is, insert 1 record in one table to record that a transaction took place and insert multiple records of individual line items that are on a form into another table. The form currently uses recordsets to populate drop down and is inserting data into a non-normalized database.

Thank you in advance.

Jim

see if this helps

www.aspfree.com/c/a/Database-Code/Demo-on-how-to-insert-records-into-Multiple-tables-with-one-html-form-and-one-asp-form/

Regards,
Dave

[DWMX 2004]|[FlashMX 2004 Pro]|[Studio MX 2004]|[SQL]|[Access2000/2002]|[ASP/VBScript]|[XP-Pro]
If you like online gaming, please register @ www.nova-multigaming.com