Hi Naomi,

It does not seem that anything is working. I have even copied the two cursors to two tables and tried to play with it and still nothing works. The first UPDATE statement works as shown below, but when I replaced it with the second UPDATE statement, the notes does copy to the other table. I am not sure why the second one does not work. It seems the same to me except all the notes from each partnum will get updated.

OPEN DATABASE testdbase
SELECT crsbom

* First Update - works fine
UPDATE crsbom SET notes = 'Sample notes here' ;
WHERE crsbom.partnum = '101010'

* Second Update - does not work???
UPDATE crsbom SET notes = mynotes.notes ;
WHERE crsbom.partnum = mynotes.partnum

Please help. Sorry for the trouble...

Thanks,
Sam