For reference I am an Excel Pro but and Access idiot and I want to make sure I set this up right.
The big picture is I work in Manufacturing, We take big mettle sheets and cut them into smaller panels for different jobs, sometimes there is leftover material that we save, but currently do not track.
Example:
I have left over yellow material on skid A for Airport 1
I have left over green material on Skid B for Airport 1
I have more left over yellow material on Skid C for Airport 1
I have left over yellow material for Car Dealership 1
eventually I want to be able to look at all of the skids of materiel for Airport 1
And also I want to be able to look at all of the skids of yellow material regardless of what Job
I will figure out all of the queries and forms on how to view this (a learning/training experience for me)
but I cant seem to understand/figure out what my beginning tables should be.
Any help is greatly appreciated.