Pls I'm new to programming(vb.net 2008). I am designing an office inventory management software. I have three forms for Products, Stock-In and Stock-Out; each having there tables in the sqlser 2005 database. Pls how do I code the application such that when am doing a stock-out, immediately i select the item name from a combo box, the left-over quantity of the item should be displayed on a text box. Also when i select the quantity of the item going out(i.e. stock-out), the number of quantity chosen should be deducted from the database table of the product or stock-in and also updated...Pls kindly help me out with this.