when moving records from one table to another using the Append command the desiered records are moved over, but the memo file keeps growing....and growing and growing, I don't know if it ever ends..... It is also very slow (Maybe that is because of the bloating of the memo file)

I am using the following lines in VFP7

use table2
Append from table 1 for id = 123

Any ideas would be appreciated.

Thank you Cicilia