I want the record in the database to be deleted but while deleting the record should not be actually deleted but it should be marked with "*"
and while maintaining the database the records marked for deletion should be deleted permanently. Also the user should have the option of undeleting the record before the record is permanently deleted.

I would also like to know the codes for compacting and maintaining the database.

Thanks,

Hansa.