I am trying to build a database wherein I store all inputs of adding a stock and another form to removing the stock, how do I create a page wherein when I putin a Product ID it shows up a complete summary of stock in hand in various locations? And do I create an indirect table to hold these values which are updated whenever there's a stock addition or removal?

Totally new to this software so looking fwd to some immediate help!

Thanks

Amit.