>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?

Chuck,

This is a misunderstanding of the docs on your part. The FOR clause in the APPEND FROM command is applied to the target being appended to and not the source being appended from. That means in the example you stated above, only those records that would end up with Country = 'Finland' in the table being appended to will get appended.