Before I get started. . .

[Guest]

I want to create my own personal database of recipes. Probably a basic one
by the standards of any of the MVPs out there who may be willing to help.
What I want to do is the following: Table to include the recipe name,
ingredients, and instructions; a table to list just categories (like
casserole, chicken, beef, cookies, etc. - to be used in a combo box and saved
to the recipe table); a form to input my recipes in to save to the first
table (will include the combo box mentioned previously); a report so that I
can view/print my recipes; a report to include only the ingredients needed
for each recipe (to be used as a shopping list); a query to select multiple
recipes for the shopping list; another table/query, or whatever would be
easiest, to add other items to be added to the shopping list (non-recipe
items such as paper towels, shampoo, soap, etc).

Guidance would be greatly appreciated on how to map this all out and make it
work. I really don't want to rip my hair out over this, it is thinning fast
enough on its own!

Thank to anyone who is willing to help me out!

Teri.

 

[Guest]

Save yourself some time:
http://office.microsoft.com/en-us/templates/TC010186351033.aspx

Barry

 

[Guest]

Thanks Barry!! I had to download manually because the template is for Access
2000 and I have 2003. But I will try it out in the morning, as it is getting
quite late where I am right now and I need to get some shut eye. I was
really surprised to get a response so fast!

Thank you again, and if I have any problems using/mondifying it I will be
back.

Teri.

 

[Guest]

Okay, I have modified the database as far as I can without help. I have
created a new table and form. the only items on the table are "other items"
which would appear on my shopping list besides the ingredients needed (ie
shampoo, soap, trashbags, etc.). I have created a query which will only pull
up those items in this table which I have a check box checked off. Now I
need a way to combine this query with the query I have created which will
allow me to pull up just the ingredients I want for my recipes to create one
shopping list. My "Other Items" table is not related to any other table in
the database, and I am not sure how I would relate it since this table
doesn't contain a recipe id or even really any food to speak of.

Thank you!

Teri.

 

[Ken Snell \(MVP\)]

I don't have a good mental picture of what you're modifying, but you will
need some type of a related field in the "other items" table if you want to
relate it to recipes or foods.

Are you just wanting to add these "other items" to your grocery list even
though they are not part of any recipe or food? If that is what you seek,
then you must use a UNION query to "add" the two lists together -- the one
that is based on items needed for recipes, and the one that is based on
items not needed for recipes.

The general syntax of a UNION query is this:

SELECT * FROM TableNameOne
UNION
SELECT * FROM TableNameTwo;

Note that you must be selecting the same number of fields from each table,
and the "corresponding" fields (the first field being selected from
TableNameOne and the first field being selected from TableNameTwo, etc.)
must have the same data types.

 

[Guest]

The database I have is a template from Microsoft. I have modified it so that
I can input my recipes and generate a shopping list of the ingredients.
Since I do my grocery shopping every week, I also get other things that are
not related to the recipes in any way. So you hit the mark in your second
paragraph. I will have to add some fields to my "other items" table, and do
some rearranging I think, and will try the query. I will let you know how I
make out.

Thank you so much for your help!
Teri.