Linked tables need help

Hi, I am trying to do y first project on bubble.

Its will be a recipe book with food cost calculation.

So I have a table with ingredients, unit of mass and price:
Ingredient name - text
Unit of mass - text
Price - number
And another table with recipe, included ingredients taken from the first table, amount of each ingredient.
Recipe name - text
Ingredients_in - list of ingredients
ingredient_amount - list of numbers

Will the amount of a certain ingredient correspond to the ingredient itself in the table?

And what workflow I need to apply to receive in output a table with ingredients with mass and calculated prices for chosen recipe?


Put a repeating group and based on the Ingredient you select (Dropdown box) RG can behave as linked

Hi there, just wondering if you ever got it to work. I am struggling with a similar issue