Unless a toolbox has a last name, that field doesn't belong there so maybe you haven't mastered normalization yet. Only attributes (fields) of an entity (table) belong in that table. If you're storing the name of the toolbox then ok, but I kind of doubt it.
The nature of the process this is supposed to support isn't 100% clear to me at the moment.
You care about the location of a tool that has been identified as being in my toolbox ; e.g. top left drawer - and again, I can only have one toolbox?
Then you have a bunch of form controls and no fields in your tables for them (e.g. work center, date(s) comments).
There's no visible way to store inspection details and history according to your tables.
Doesn't look much like post 9 so it's kind of obvious there's a disconnect between what I thought the process is and the process you've designed for. Doesn't mean you're wrong; just means we're not on the same page.
Last edited by Micron; 04-23-2021 at 10:18 AM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.