chewy
SuperNintendo Chalmers
- Local time
- Today, 22:08
- Joined
- Mar 8, 2002
- Messages
- 581
I am making an inventory database that will record how much inventory is on hand for our department. I want to record for example how many pens are on hand . How many pads of paper. etc... I have a question about how to link everything together. I want the Inventory table to look up what kind of packaging a product comes in (ie. box, pack) and how many come in the respective box or pack. I have attached the relationship and deisgn views of my tables. Maybe someone could tell me how to better set this up and how to put it all together so that everything is relational and not storing myultiple data.
Please any ideas are welcome! I can give more info if this is too vague.
Please any ideas are welcome! I can give more info if this is too vague.