I have a form with a few textboxes for user input. The form is to remove quantity from a pallet. I cannot seem to figure out how to query my database and update the quantity based on this information.
I want to select palletid, quantity from tblPallets where palletid = txtpalletid.text and then subtract the value of val(txtQuantity.text) from that pallet.
But which object so i use? Do i do it via code or those drop in objects from the toolbar? How to I get a textbox value into one of those toolbar sql objects?