Wonder if there is an easy way to Append records from one table to another when there are additional fields in the master table (additional fields and NOT different fields). I have no problem when there are no memo fields. But with memo fields, I am having a lot of problems appending from one table to another. Keeps giving me either "can't find memo file..." or "invalid filter".

Did anyone else figure out an easier way to append or move records from one table to another.

Note: I have absolutely NO problem when a memo field is not involved. I know about the FPT file and I AM making sure it is there in the folder, etc.

Any help would be appreciated.