Russell,
>But I'll try what you suggest again because you are doing this . . . FROM data\branch10\worder10 . . . and though I think I did that way once, I did not do it with the UpdateNameList set up with the PK field.
The UpdateNameList setting is your missing link, I believe. The key field MUST be included there so CA can figure out the correct WHERE clause for the UPDATE statement it generates.