Please see my new database where I have made some changes .
Please analyze the Product Table. The IntitalQuantity field needs to update each time an item is sold. I will have a Complete Command Button above on the Main Form with the subform on top. When the user enters a sale and selects the Complete Button, I want an update query to run updating the InitialQuantity of each Code.
For Example: User enters a Qty 10 Units. The Initial Quatity in the Product Table is 1,000 Units. When the sale of 10 units is entered and the Complete button is selected, I want the InitialQuantity field to Update in the product Table to 990. The number 990 will be the new QTYAvailable for a product when a new order is made for the code.
i hope this makes sense.
Any help is very much appreciated.