I have a table named planning and within this table users enter records by the way of a GUI. The table records the key and other information. Like:

Key                            Name                Colour  
T56*SS2003*SK103*SAMPLE        Shirt               White
T56*SS2003*SK103*SAMPLE        Shirt               Blue
T56*SS2003*SK103*SAMPLE        Shirt               Green
T56*SS2003*SK103*SAMPLE        Shirt               Black

What happens when they copy other information is the new information is shown and the old records are marked for deletion at table level. What I would like to do is to provide some code that searches for all occurences of the key and Mark the records that are NOT marked for deletion and Unmark those records that are marked for deletion. Basically to bring back the old records whilst deleting the records that the user has just copied (Like an UNDO command).

Many thanks in advance

Neil Lewis
IT R&D Manager
Velmore Ltd