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.
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
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
that's great, thankyou!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
