In general, it is better to consider deleted records as "gone". Don't delete a record unless you want it "gone".

With views, you can easily work with temporary data from a table, and undo it later, or also, save it later, which may depend on a condition.

>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