Ok, maybe we are on the wrong track... Someone else mentioned making sure that the field names where the same (the code field) (also, do they have to be the same data types?) hmmm... If all else fails, replace the append from statement with list workpo.code and see what the values in the table are...

>>I can't see what's wrong, other than the tableupdate idea and maybe moving the flush before the append statement.
>
>I did that and got an error message saying it requires buffering mode, which then tells us that I am not doing any buffering???
>
>Chuck