I am building a database for employees and want to also keep track of the uniforms we have given them/they return as well as the amount of uniforms we have left to distribute in house.
I figured out a way to link the people to the uniform sizes so i can easily control whats in house and who has which size shirt by linking the employee names to the uniform table and then counting the names to see how many shirts are out. But i cant figure out a way for it to account for multiple quantities of shirts - that’s the roadblock i am stuck at. It wont let me assign someone’s name to a field more than once, so it only subtracts 1 shirt from inventory (1 shirt per name), but most employees have multiple uniforms. How can i get it to account for different quantities for different people?