Inventory_DataBase_Design Advice Needed

[ebelingbl]

Hello. I'm fairly new to access. I am trying to put a DB together for a small warehouse. Have 1000's of parts and many bins to store them till they are sold. I am trying to figure out the best way to track this. My first thought was to have a table for the different parts ( Description ) and a table for each Bin ( part number, quantity ). One problem is how to collect the quantities of individual items from multiple bins and put the sum into another table to represent total available inventory of each part. I feel like if I could get past that hurdle I should be able to achieve my goal. Or is this a bad approach? I appreciate any suggestions and help. Thank You in advance.

[orange]

You should do some research on data base design and normalization, just to get an appreciation of the concepts involved.
Here's a tutorial that should help you with concepts.

Then do some research on inventory data base and see what others have done, learned.

And you should read this several times. Then write a 5-6 line description of what your business is in clear terms.
Then start your design.

Good luck.

[ebelingbl]

Thank You! I appreciate the help.