Hi Gnana ---

That's an interesting name! What are the roots?

I guess the answer depends on the business case to create/maintain a history. Is this backing up each record as it's saved or a periodic backup? Is ythe backup akin to saving current transactions at closing?

I think more info is needed?

>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.