Skip to main content

Hi!
I'm trying to design a database where products are made up of a number of different units. Let's say there are a maximum of 10 types of units, but the quantity differes from each product.

For example:
The product Box1 consists of 64 units of part X and 64 units of part Y
Box2 consists of 12 units of part X
Box2 consists of 128 units of part X and 400 units of part Z.

How do I design the database to make it easy to add a new product and enter information about the units?

You could try setting it up with 3 tables like so:
1. Boxes



2. Parts

3. Line Items


Does that make sense?  And here's a link to the base


Reply