>In an app I am working on, data need to be migrated from one table, item, to another tanle, olditem, once per year. There is a general field that contains a photo of the item. There were problems with that though. Both tables are involved in many relationships, so dropping a table, selecting into and re-addidn the table could be problamatic. I need a fast method of doing this, so any help/advice will be appreciated.



When you say migrated I assume you mean backed up and not moved out of item permanently
So I offer you the following assuming the field names/datatypes are the same.

use olditem excl
if notkeepinghistory
   zap 
endif
append from item