Client/server DB using Access-ASP-VBScript

I have managed to build a nice db that people can connect to through the intranet, still I want more. I want my associates to be able to use an old Post as a template. main table: Subtable: No relation in Access.... OrderID(autonr) ProductID(autonr) Name OrderID(nr) Age Name_of_prod The First Post would look like this main table: Subtable: OrderID=1 ProductID=1 Name=Norton Smith OrderID=1 Age=36 Name_of_prod="Banana" ProductID=2 OrderID=1 Name_of_prod="Mango" The OrderID is the glue that keeps thing together. The next year I want to make a new similiar order, a hard work, still I remember that I have done the Job before and I pick up the Old Order. OrderID in the main table will now be 4096, I change my age to 37, When I save this record I have only managed to change OrderID in the Main table and saved the post under this new ID, not in the sub table, it is still OrderID=1 and the connection is broken. So My simple question is If I can copy the aboves ProductID 1 and ProductID 2 and add OrderID 4096. Copy is the solution............. Please reply on my mail! I'll be pleased. mvh. ingimar