Quote Originally Posted by jmcilhinney View Post
The problem is with one (or more) of your TableAdapters. You're trying to save records that you've edited but your TableAdapter has no SQL code for that, hence the error message:Either you told the wizard not to generate an UPDATE statement when you configured your TableAdapter or else the wizard was unable to do so. In the latter case it would be caused by either:

1. Your SELECT statement joined two or more tables; or

2. Your SELECT statement didn't return the table's primary key.

My guess is option 2 and because you haven't given your table a primary key in the first place. You can't update a record if you can't identify it and the primary key is specifically for the purpose of uniquely identifying a record.
You are right on. I will make the changes and let you know. Thanks!