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?
