Creating Log file for table
I am working on solution that is loan company, one of the target goals of this solution make everything recorded on log entry. for instance, if some one pay the money it record under the loan payment, as well as it should show under the activity log, if some one delete the loan payment , it should delete from the loan payments table but it should recorded that activity log on another table. So its like mirror the table but does not let delete it keeps everything record what happen to loan payment table.
I was thinking what to do to overcome this problem, any body have brilliant idea ?