First off I have learned through this process that I suck at databases, I have learned everything I know (still very little) about them in the past 4 weeks and have gotten my butt kicked.
I am trying to build a weekly meal planning database, that I can export 10-15 meals per week document with compiled shopping list by aisle/area of the grocery store. I am about to pull my hair out. I have used some of the ready-made bases and those get me there partially but I am getting lost in how to compile the weekly shopping list (ingredients compiled and labeled with recipe its associated with) and how to export the weekly meal plan in a separate document (recipe name, ingredients, instructions)
Anyway I have just hit a caffeine and knowledge wall any help or guidance how to pull this off would be much appreciated.
Here are two pics of the tables I have developed