I have made my first app but having never done anything like this before, I am struggling with some of the basics. The app is connected to a single Sharepoint list that contains an inventory of the cleaning chemicals that we use on site. I have a standard Browse Gallery, Edit Form and New Form pages. The Sharepoint columns include one for stock quantity. Currently, the stock quantity is changed by simply editing the value up or down in the Edit form and submitting it. This is working fine.
But, I would like to keep track of stock use using a screen that has a dropdown list where you can choose one of the chemicals, a date picker, a location for the factory area where the stock has been used and an input for stock out where you can simply put the number of items that have been used.
I want the stock out numbers to then update the stock quantity for the chosen item in the background Sharepoint list AND I would like to be able to view a list of all the stock out movements so that, for example, I can look at the pattern of chemical use with time in a given part of the factory.
Any tips about how I could achieve this would be much appreciated. I wondered if I should make an extra Sharepoint list for Chemicals Stock Out but I don't know how to make it 'talk' to the other list so that when stock is marked out on one list, it reduces the stock qty in the other. Or is there another way of monitoring the changes in stock numbers that would be better?
Thanks.
