In the attached DB When I want to cancel a record I am prompted as - "Are you sure you want to CANCEL the record?" When I click "No" the Donor No. should revert to the original Donor No. But it remains "1" (i.e. --CANCELLED--).
How to revert it to the original Donor No.?