View Single Post
  #2 (permalink)  
Old December 6th, 2004, 05:30 AM
Ray Pinnegar Ray Pinnegar is offline
Authorized User
Join Date: Jul 2003
Location: Stockton on Tees, , United Kingdom.
Posts: 73
Thanks: 0
Thanked 0 Times in 0 Posts

Suspect that the record you are trying to update is a result of a join of tables where there Primary and Foreign keys are not truly unique and thus can't update.

Suggest that you run a UPDATE query using the unique index of the record in the OrderDetails table only.

Cheers Ray
Reply With Quote