>how can i have some sort of an "audit trail" in my grid? i want to be able to save the record before and after the user changes each columns' value.
>
>pls help. TIA.
For a commercial solution, there is FoxAudit.
To do an audit-trail yourself, see my introductory article:
http://www.utmag.com/May2003/Page18.aspThis is not only for grids, but for changes in general. Any change will be audited - whether you change it in a grid, with a REPLACE command, etc.
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)