might be some confusion u’ll get after reading this but its a try…I have an application working on web this is regarding details of Stationery , on my form apart from requester form also i show the stock database .
for example if the stock of notebook is 30, and at the same time some five people will raise the request for the same, at that time how i can display the database accordingly to each user is it possible that when any one raise for 5 qty of notebook, at that moment the entire database will change automatically for all the user or i will show the 30 to all, after submitting there request i’ll change it later .
also i dont want to restrict my user, that they can raise one request at a time, any one can raise anytime .
can anyone give me suggestion what will be the best option for this or how can i handle my database and regulate it easily