Repeating Fileds or Portal for Ingredients List
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?