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