I am trying to create an item quota management system for a store.
The gist of it is I have a list of employees, each with a yearly quota on the amount of items that they want to take get.
I have a form where a user id is entered and a report showing their nonzero item quotas should be displayed.
My main issue is that the item list itself is not static and items have to be added and removed fairly regularly.
Is there any guide somewhere or some assistance on how exactly one would structure this database?
I have tried looking for quota management system , however the results are ultimately unrelated to what i am looking for .
any help is appreciated thank you
My current solution has a list of employees with the various quotas as different fields in that table is this the right approach?
Catalin Coman is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.