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.