AnsweredAssumed Answered

Inventory

Question asked by letra on Dec 13, 2010
Latest reply on Dec 15, 2010 by letra

Title

Inventory

Post

Hello,

I have an established database full of different products. I have a means to enter inventory changes for each product, but need the ability to break down my inventory according to two factors per product: size and color. I currently have a products table that is linked to an inventory changes table, and an items table that is used on an invoice layout for sales.

How do I do this? Do I need two new tables...one for sizes by product and one by color?

Thanks!

Outcomes