Jim,
>The most complete audit trail I ever built was for a company in NYC. We used a table with three memo fields adn timestamp and user id field. When a use modified a record we did an AFIELDS() and saved teh resulting array into one memo, then we saved the original data into another memo and finally we saved the changed data into the third memo
come again? you saved the before edit data to one memo, after edit data to another memo, < scratching head > and what was in the third memo field?
(Sounds like a much better solution than the vertical table approach I'm used to seeing at my current job.)
Roxanne M. Seibert
Independent Consultant, VFP MCP
Code Monkey Like Fritos