AnsweredAssumed Answered

Portal-within-a-portal relationship and formatting

Question asked by zack_fmform on Dec 20, 2018
Latest reply on Jan 2, 2019 by philmodjunk

Hello. I’m working on a recipe part of a database (that also includes inventory of prepared food and ingredients.) I’m getting hung up on two aspects, formatting recipes and pulling the related ingredients info into a printed label when I cook food. I think some of these concepts might be related, so I’ll make a single post.

 

Recipe formatting question

I’d like to lay things out in the style of Modernist Cuisine.Screen Shot 2018-12-20 at 2.28.09 PM.png

https://modernistcuisine.com/recipes/the-colonels-fried-chicken/

 

I’ve created tables:

RECIPE ——< INGREDIENT_LINE_ITEM >—— INGREDIENT

 

With this, I have a portal to INGREDIENT_LINE_ITEM on a RECIPE layout, and I can put ingredients in.

 

I need to be able to group multiple ingredients together (as Modernist Cuisine does with horizontal red bars). And I also want procedure steps that relate to the group of ingredients, not tied to a single INGREDIENT_LINE_ITEM.

 

Do I need another join table, something like:

RECIPE——<PROCEDURE_LINE_ITEM>—— PROCEDURE——<INGREDIENT_LINE_ITEM>——INGREDIENT

 

And if that (or similar) is the answer, how can I display it with the example layout? I’ll have a portal to PROCEDURE_LINE_ITEM with a portal to INGREDIENT_LINE_ITEM inside it… which doesn’t work right?

 

Does anyone have specific tips here or concepts I should investigate?

 

Ingredient labeling question

I have a table I omitted above:

FOOD_PACKAGE >—— RECIPE——< INGREDIENT_LINE_ITEM >—— INGREDIENT

 

FOOD_PACKAGE holds details and a label layout for an individual prepared package. I’m trying to create a calculation field that stores related ingredients, reaching through the INGREDIENT_LINE_ITEM join table into INGREDIENT. So in the layout, I just put a text reference to that field that shows any number of ingredients. My calculation on the FOOD_PACKAGE table is just:

INGREDIENT::ingredient

 

This works to copy from one record, but doesn’t get all of them. Maybe this relates to the portal-in-a-portal concern above, or maybe I need a script with more steps? Again, have any specific tips or concepts I should investigate?

 

Thanks much!

Zack

Outcomes