I am working on a table to track products produced. My tables are the following.
Parts - These are parts used to produce products
Products - These are products produced from the parts
Parts to produce junction table - This is a list of parts used to create the products with variations of parts used per product, and total weight etc. (many to many relationship)
Build List - This is a list of products for production to build.
How do I create a new table “parts to build list” for each build list automatically? I would like to select a product, and in another junction table create a copy of all the parts needed to produce from the “parts to produce junction table”. I used to use Filemaker, and this was a simple click of a button to automatically create records in a junction table when records were created in a linked table. I’m assuming this is available in Airtable, but I haven’t seen the option.
Thank you in advance for your assistance.