Forms PLS Help: Creating template records

I have a system where users enter orders. An order consists of 1 record of general info and several records of detail info. The orders are set up as a master-detail relationship.

My users need to create a new order with info from an existing order. (Basically, the existing order becomes a template for the new order - and the existing order should remain unchanged). I currently create the new order by doing an explicit cursor and querying the old info into the new order one row at a time, but I wanted to know if anyone has a more effecient, different, or unique way of copying a master and its detail records to a new master and new detail records.

Any help would be greatly appreciated ! Thanks in advance for any responses!

prodick_at_notes.cc.bellcore.com Received on Mon Feb 10 1997 - 00:00:00 CST