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 advanceNeil Lewis
IT R&D Manager
Velmore Ltd