i dont know which one shud i put as a primary key. cud u all guide me how to solve this problem. i'll explain the actual cycle of our stock transaction and hope this wud help.
Table RegisterItem
For example: Current quantity of item "stapler" is 30. Our new stock-in is 50 then we have to...