AnsweredAssumed Answered

Repeating Fileds or Portal for Ingredients List

Question asked by shronk on Apr 15, 2012
Latest reply on Apr 16, 2012 by philmodjunk


Repeating Fileds or Portal for Ingredients List


Hey there,


I'm working on a recipe database and just got stuck.

For my recipes I have various ingredients that I'd like to link to their Ingredient Table so I can see all the recipes that use this ingredient and get some more information.

Should I just create 3 tables (recipe, ingredient, details) and add a portal into my recipe or is there a better way to do this? Would repeating fields work?

Wouldn't I make my database just too big for nothing if I created another table that would list a measurement and an ingredient for every single recipe?