>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
Alek Massey
- The only stupid question is one left unasked -