Hi Sergey,

I have used the PACK command, and the PACK MEMO on the original table (table1).

Then I use the following commands:
*************************************
use table1
use table2
append from table1 for id = 123
*************************************

table 2 will be populated with all records with id = 123, and you can access their corresponding memo files.

The table2.dbf file looks fine, but the table2.fpt file looks like it is an exact copy of the table1.fpt file (very big). I belive what is taking time is the copying in to the fpt file one record at the time.
I can PACK MEMO on table2 when all the copying is done. This will get rid of all the excess memo fields(Making the fpt file the "right size"), but I don't belive this is how it is suppose to work.... It takes way to long!!

The reason I am using the Append command is that some of my tables have General fields, and I was looking to work with as generic code as possible.


Cicilia