>>Nadya,
>>
>>The FOR clause on APPEND FROM acts on the source of the append not the target.
>
>Exactly what I was thinking. So, where VFP allows you to perform some checks on the data, it won't be able to evaluate stuff like Recno(). Now I think of it, this will be the same as FOR NOT DELETED() won't work (never thought of it this way ;).
FOR ! DELETED() works when importing a DBF file; RECNO() is a problem, since the file isn't open to give it an alias to reference.
>Knowing this, it can be solved by having a nRecno field in the source table (obviously equal to Recno()) and you will be able to test for that (with WHILE if possible) ...