Hello,
I have a form on which user enters information about what item he bought. If he chooses ID for this item which is already in warehouse, system must automatically add the amount to the one which is already in warehouse. But the problem is that in my code the system adds all the values depending on ID match but not the current record. I mean, if the items called "Box" with ID "12" and amount of 5 was bought on tuesday and the same item is in the other table called WAREHOUSE the system add 5 boxes and that ok, but the next day the same item with the same id was bought and the system still uses the amount of tuesdays and this days when it adds values in warehouse table.
I do believe that the main question is " How to connect the exact record on curent view of the form to table not all the records that exist under same ID?"