i am trying to implement an application in order to keep rercords of the stationary of a company. i have a combo box named ComboP_Name In FormProducts form,which is getting the values from the ProductName field of products table and ActualQOH is the table which is getting the corresponding quantity on hand value from the same table, the problem is it does not work that way. when i select the product i want from the combo box the textbox does not get the corresponding value. if i still try to update it will generate a msg saying
"the cahnges you requested to the table were not successful because they would create duplicate values in the index, primary key or relationship. Chnage the data in the field or fields thatcontain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again"
i am not trying to update the primary key of the products table which is the ProductName, i am just trying to update the Qty on Hand.
but when i use the navigation keys o when i enter a number their it will redirect to the product i want and update the qty on hand.
i need help and need to hand this over by tomorrom. i have lyk 21 hours...
thanx in advance