>Hi
>
>I am designing and implementing a database using VFP 6.0. I am having to move the data from the working database to the history from time to time. I was wondering if there is any standard methodology in getting this accomplished. I would appreciate it if some would briefly explain the strategy of doing it or point me to some books/documentation I can gather this info from.

The exact way and scheme to achive this depends on the exact setup of data you have. basically I would say you'd want to have a timestamp field on your tables
one for creating another for update, this way you'd have all the information you need to decide which records had already been archived or need to be archived etc.

Arnon