How to set up tables

[dirtbiker1824]

I'm trying to use access to make a recipe data base. What I want is a table with all of my ingredients and their associated parameters (unit of issue, price, UPC etc..) then another table that has my recieps and instructions. There will be a many to one relationship between the ingredients and the recipe.

The part I am having trouble with is how to specify the amount of each ingriedent I need. Do I need another table to do this? Here is an example

Recipe (UniqueID, Name, Instrucitons)


(1, Sandwich, Stack ingredients between bread)

Ingredients: (Unique ID, Name, Units)
(1, Bread, Slice)
(2, Ham, Slice)
(3, Cheese, Slice)
(4, Mayo, Tbs)

Then I want a Recipe Form to look like this:

Sandwich
Stack ingredients between bread

2 Slice Bread
3 Slice Ham
2 Slice Cheese
1 Tbs Mayo

[June7]

Check this out
http://office.microsoft.com/en-us/te...001018635.aspx