One product many parts

Topic Labels: Base design
314 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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?

1 Reply 1

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

Screenshot 2024-01-31 at 8.47.16 PM.png

2. Parts

Screenshot 2024-01-31 at 8.47.23 PM.png

3. Line Items
Screenshot 2024-01-31 at 8.47.19 PM.png

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