Hi all

Using ASP/VBScript.
Whats the best way of adding data to a table and its related child table. eg. a orders table and order details table.
The order table only has one entry to add, but the order details table has multple enties to add.
I know the Parent table (orders table) uses the customerID, and the child table(details table) uses the OrderID.
But I don't know how to add multiple records with only 1 Update.

Any ideas in solving this are welcome.
I havn't add any code here yet because i am tring to plan it out first.

Would it be the same if you have multiple child tables.

Thanks<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
Thunderchild



Edited by - thunderchild on 26 Aug 2005 09:42:02