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.

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.

HTH

>In the help (both "F1" and book) for APPEND FROM, it states in the example that APPEND FROM customer FOR country = 'Finland' would mean that FP supposed to look in the customer.country and append ONLY 'Finland' from customer into the backup, is that correct? How come it does not really work that way in the real world? Are there another command or better way of doing this? INSERT - SQL will not work, since I am NOT using any form (SCATTER/GATHER). Any idea or what to do about the old APPEND FROM command?