I have a half dozen tables that I need to track changes that are made. My first idea is to create copies of the tables (on the sql server) and then when I do an update or delete put a copy data into them. But that doesn't seem like the most efficent way. Anybody of any other idea's. I'm using spt exclusively, and not vfp remote views.

Kirk