I am coding a client-server application which uses data adapters to update a database. My app contains a screen displaying the details of a Quote (Id, Creation Date, Creator etc.) along with the individual Quote Items (Item Id, Description, Price, Quantity). There is a one to-many relationship between Quote and Quote Items (which is implemented in my dataset).
I have no trouble creating a new Quote with various Quote items, but when I try to update an existing Quote I receive the error: Concurrency violation: the UpdateCommand affected 0 of the expected 1 records.
I am the only user of the application so I don't understand why a concurrency error is occuring. Can anyone tell me what I should be looking for?