I just bought a subscription to Lynda.com and I am learning Access 2013 Essentials. I am having a hard time understanding how to set up my particular project.
Mission Statement
The Provision Expert database will provide Yacht Chefs the ability to easily plan weekly meal plans and generate accurate and extremely organized shopping lists.
Mission Objectives
感rovide an easy access list of user defined recipes sorted by tags.
感rint out a professional organized weekly menu.
感rint out an organized shopping list, separated by types of ingredients.
幌asily add, delete or edit recipes.
廈ave a rating system for how much people appreciate a particular meal.
This is the basic idea and I am going to start with basic questions.
---------------------------------------------------------------------------
I am having a hard time understanding how to create a recipe and add ingredients. So lets start with ingredients. I am assuming because no ingredient will repeat, it might be ok in this situation to make the name of the ingredient field a primary key. With that said it will have these fields: Name, Type, and Unit. Unit, by the way, might also be a foreign key to another table for complex conversions, but this is hard to say, because I am so new to Access.
Questions....
1. Can the name of the ingredient be the primary key since they will not repeat?
2. If I create a recipe table, how would I add multiple ingredients? I have learned that you do not want multiple values in one field... SO how would these two tables relate?
Edit: I have already seen this template http://office.microsoft.com/en-us/te...001018635.aspx
Think about the ingredients being tags. There is going to be hundreds of ingredients and the recipes table will need to add any amount of these to each row. How might I go about this?