Quantity increasing when the same data enter to the database rather than adding in a new field
<p>i have a system which can used to take stocks, so when i enter the Item id in the text box, program retrieve the item-name, item-price, Qty of the Item ID and display into the Grid View and it is stored into the another table call stock-data. that means it stores the qty as a 1, so if the same record of the item ID searched again, it should stored to the stock-data table as qty 2. when i type the different id,it should store as new record and qty will be 1.</p>

<p>i am using the access database to do this work</p>
