>If the field Country does exist in the destination table, VFP will only test the first record from the original table and append no or all records depending if the first record match the condition.

Isn't it still wrong though!? Shouldn't it supposed or meant to append ONLY 'Finland' and not others!?!?!?!?!?

>A solution would be to add the Country column to the destination table or use SCAN...ENDSCAN with INSERT-SQL. You don't need a form or the SCATTER/GATHER combination to use INSERT-SQL.

Dear "Beats-me" professionals, can you please please at least code a little sample. I am not good (if not at all) with SCAN...ENDSCAN. I just want to copy record(s) to other tables and then delete 'em (SET DELETED ON is on) and then go to the next record (GO TOP or LOCATE since the previous record(s) is already deleted). Man, I am still paining my stomach with the program seeming endless with buch of old-style programming/coding. If you don't mind, I really like to post (or even email) the coding I have done so far so we can look at it over together (it was supposed to be due today, but I have no idea if this will ever be due by Friday!). So far, it has about 150 lines of codes.