I have a form where I enter in purchase details, including the ID, when I enter these details into a sales table(which means the item has been sold). How can I get a query to lower the quanity value for the product in my inventory table, thus the system has lower quantity as they have been sold...