Make change on Records

I'll make my post clearer now.
I have an application, the user are able to change records in this
application.
Also, there's a button called "What If".
After the user pressed the "What If" button, the user may change the records
and save it. When the user open the same record again, all the changes is
there. (Pls. notice that the user is still in the "What If" environment).
Somehow the changes are save to a mirror table record.
The changes would only affect the real records until the user press another
button called "Accept changes", in which all the changes in the mirrored
table would be adapted into the real record.
Is there any way i can do it via MS Sql Database?
Pls. advice and thanks in advanceDid you read my previous post?
"pcPirate" <pcPirate2003@.hotmail.com> wrote in message
news:O9SlS5e#DHA.4084@.tk2msftngp13.phx.gbl...
> I'll make my post clearer now.
> I have an application, the user are able to change records in this
> application.
> Also, there's a button called "What If".
> After the user pressed the "What If" button, the user may change the
records
> and save it. When the user open the same record again, all the changes is
> there. (Pls. notice that the user is still in the "What If" environment).
> Somehow the changes are save to a mirror table record.
> The changes would only affect the real records until the user press
another
> button called "Accept changes", in which all the changes in the mirrored
> table would be adapted into the real record.
> Is there any way i can do it via MS Sql Database?
> Pls. advice and thanks in advance
>