It's an inventory control program. People are assigned items for a job.
I lost you here.
People are assigned items for a particular job.
Maybe rather than "inventory control" I should say it's a an assignment program. An administrator will use this to assign specific equipment to crews as they go out to a jobs. Once the equipment piece is assigned, it won't appear as a selection until after the job is done and the equipment checked back in.
My main problem is conceptually how to handle the storage of some of the smaller items that may or may not have to go out to a job site.
I once had this problem.
I solved it by defining 3 categories of equipment:
- single items (each has an ID)
- suitcases (which were associations of items into a collection of specific ID's)
- sets (which were associations defined at the single item level, but extracting the available ID's from the current unused "inventory").
Maybe this can ring a bell for you.