>Do you have any idea of how to save the same information in other table, like a mirror table?
Well, personally, I think I would just go for a regular backup.
There is a commercial product, FoxAudit, that doesn't exactly create a mirror table; rather, it keeps an audit trail, that is, a record of what changes were made. From there, it provides the functions required to "roll forward" and "roll back". Roll back means undo several changes, to have the data as they were in a certain date. Roll forward means to recover a backup from a certain date, and then re-apply all changes.\
If you want to do the same, but without buying anything, take a look at my article
http://www.utmag.com/wconnect/wc.dll?9,7,10,1476 (also available in Spanish). Roll-back and roll-forward capabilities are not included; my article is just a simple demonstration of the basic principles.
You could also adapt the same principles to create a mirror table, but an audit trail with roll-back and roll-forward would probably be more useful.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
