>>No, it means only the fields in the key field list will be used to compare to the source data to determine if there is an update conflict. All changed/new data will be updated.
>
>I was just typing a message (stating that I needed more coffee and to get rid of this cold) wherein I just "got" what you said. I seem to remember having to change that at some point because I was getting some type of error saying that it was too complex a query. Of course, I can't find any notes on it right now :) I'm going to give it a try.
>
>But one other thing I think I don't understand.... my key field shouldn't change... that's why I made it key (or at least that's why I thought I did). Arrrrrrrgggggggghhhhhhhhh :) :) :) :)

That is why this work around almost always works. There is no update conflict detected so the update procedes uninterrupted.