copying rows

From: Darren Woodbrey (darrenwoodbrey_at_hpfairfield.com)
Date: 08/02/04 

Date: Mon, 2 Aug 2004 17:00:04 -0400

I have a work order system with 6 tables. When the first asp form is
submitted it creates a record that has an identity field in the maintable.
it also inserts a record into the other 5 tables putting the identity field
in each table as the PK. The user then submits an asp form for each table
using an update statement. Everything is working good. My problem is when
the user wants to enter more that one work order that is exactly the same.
I want them to edit the master work order and when finished be able to push
a button and have the other child work orders update to be exactly like the
original. In short I need to update a record from another record in the
same table. Is this possible?