>Thanks for the responses Bob, David, and Cathi. I should be able to do it all in one statement. I just don't understand from your code how I can retrieve either the updated key or the key value before the update completed.

The code I showed you should be a stored procedure. Pass in the table name and make the @keyvalue variable and output parameter. You call this sp, get your value, put it into your dataset and update your dataset.

BOb