Hello im trying to build an ERP for my food business we manufacture and package fast food, so my main goal using airtable is to control raw materials, receiving of raw materials, production control, finished product control, recipes, and inventory.

Since my Finished product (recipe) consists of various ingredients, im wondering if its possible to populate said ingredients taken from my recipe table to my production table every time I add (manually) the quantity of items to be produced in the day. or if the is a simpler solution would be great, im trying to control de raw materials consumption during production.