O.K. so I have an inventory database which I have designed and I need to move records from 1 table to another, the issue is there are certain fields that will not transfer. The code I was working with (Thanks Naomi N.) was correct for transferring a whole record. My problem is where would the except clause get inserted with the scatter command?

I have searched VFP help and the examples therein only exist to confuse

the code is as follows:

scatter name loRecord memo
insert into mynewtable from name loRecord &&(verify this syntax,)
delete from myoldtable where ID = loRecord.ID

If anyone has any ideas thanks in advance

Thanks

Fred W.