how to link to a group name?

[dasprune]

Hi, I'm a complete beginner to airtable so sorry if this is a dumb question, but here goes anyway.. 

I created a product table which is a collection of parts grouped by name. I want to then use the name of each product as a single select field in a new table, but instead I get all the entries for every part within that product.

Ultimately I want to display price information for each product - sum of all the parts cost, wholesale price etc. 

[TheTimeSavingCo · Accepted solution]

You're 100% on the right track.  To get what you want, you need to have three tables:
1. Products
2. Product Makeup - A junction table between Products and Parts - this will contain the information on what and how many parts each product needs
3. Parts - This will contain the price of the parts

And so your current "Products" table is actually a "Product Makeup" table

I've thrown something together here for you to check out that I think will make things a lot clearer

[dasprune]

that's great, thankyou!