Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

how to catalog recipes

  
   Windows Help (Home) -> Microsoft Access RSS
Next:  you don't have the license required to use htis a..  
Author Message
J

External


Since: Jan 23, 2009
Posts: 2



(Msg. 1) Posted: Fri Jan 23, 2009 11:39 am
Post subject: how to catalog recipes
Archived from groups: microsoft>public>access (more info?)
At my wifes request, she has asked me to build a db to catalog her
recipes. I attmepted to use the template which was on microsoft.com
however ran into a problem in the given situation.

I have a recipe with ingredients 1-10, so I have a table with recipes
(name, yield, where it came from etc) and a table with ingredients,
however on this particular recipe ingredient 10 is actually another
existing recipe in my recipe table. IS there a way through maybe a
union query (i ave no idea hence I'm asking) to be able to list
recipes as ingredeinst as well?

Does that make sense?

Thanks for your help!

J

 >> Stay informed about: how to catalog recipes 
Back to top
Login to vote
J

External


Since: Jan 23, 2009
Posts: 2



(Msg. 2) Posted: Fri Jan 23, 2009 2:16 pm
Post subject: Re: how to catalog recipes
Archived from groups: per prev. post (more info?)
Thanks for the help, but I think I didnt explain myself very well. Let
me give you a literal example, say the recipe is for "spaghetti and
meat balls" and the ingredients are as follows:

Spaghetti (cooked)
Meat Balls
Spaghetti Sauce

The problem is that Spaghetti isnt from the can, its hoem made so
along with the recipe for "Spaghetti and meat balls" in tbRecipe there
is also a recipe for "Spaghetti Sauce."

Does this clear it up?

Thanks agai nfor your help!

On Jan 23, 3:20 pm, "Al Campagna" wrote:
> J,
>     tblRecipe should contain the name of the recipe, as well as any
> ancillary info such as Servings, Instructions, etc...
>     It should have a unique key value... such as a RecipeID.
>     That's the One side of the relationship.
>     tblIngredients should list all the ingredients.  It should have a
> RecipeID (that relates to the correct Recipe) and an unique IngredientID
>     That's the Many side of the relationship.
>
>     If Recipe is related to Ingredients via RecipeID... then you can report
> from the Recipe side of the relationship to Ingredients, OR from the
> Ingredients to Recipe.
>     Example...
>     1 cup sugar
>         Apple Pie
>         Pecan Pie
>         Rhubarb Pie
> --
>     hth
>     Al Campagna
>     Microsoft Access MVP
>    [URL="http://home.comcast.net/~cccsolutions/index.html"]http://home.comcast.net/~cccsolutions/index.html[/URL]
>
>     "Find a job that you love... and you'll never work a day in your life."
>
> "J" wrote in message
>

>
>
>
> > At my wifes request, she has asked me to build a db to catalog her
> > recipes. I attmepted to use the template which was on microsoft.com
> > however ran into a problem in the given situation.
>
> > I have a recipe with ingredients 1-10, so I have a table with recipes
> > (name, yield, where it came from etc) and a table with ingredients,
> > however on this particular recipe ingredient 10 is actually another
> > existing recipe in my recipe table. IS there a way through maybe a
> > union query (i ave no idea hence I'm asking) to be able to list
> > recipes as ingredeinst as well?
>
> > Does that make sense?
>
> > Thanks for your help!
>
> > J- Hide quoted text -
>
> - Show quoted text -

I

 >> Stay informed about: how to catalog recipes 
Back to top
Login to vote
Al Campagna

External


Since: Nov 26, 2008
Posts: 11



(Msg. 3) Posted: Fri Jan 23, 2009 4:20 pm
Post subject: Re: how to catalog recipes
Archived from groups: per prev. post (more info?)
J,
tblRecipe should contain the name of the recipe, as well as any
ancillary info such as Servings, Instructions, etc...
It should have a unique key value... such as a RecipeID.
That's the One side of the relationship.
tblIngredients should list all the ingredients. It should have a
RecipeID (that relates to the correct Recipe) and an unique IngredientID
That's the Many side of the relationship.

If Recipe is related to Ingredients via RecipeID... then you can report
from the Recipe side of the relationship to Ingredients, OR from the
Ingredients to Recipe.
Example...
1 cup sugar
Apple Pie
Pecan Pie
Rhubarb Pie
 >> Stay informed about: how to catalog recipes 
Back to top
Login to vote
Al Campagna

External


Since: Nov 26, 2008
Posts: 11



(Msg. 4) Posted: Fri Jan 23, 2009 6:35 pm
Post subject: Re: how to catalog recipes
Archived from groups: per prev. post (more info?)
J,
Hmm... that adds a bit to the problem.
I think I'd create 2 fields in tblIngredients.
Ingredient - Text and SubRecipe- Text

And, 1 field in tblIngredients
IsSubRecipe - T/F Boolean (*not absolutely neccesary)

[Ingredient] in the sub form could be a combobox based
on tblIngrediants.
[SubRecipe] in the sub form could be a combobox based on
tblRecipes... where tblRecipes *[IsSubRecipe] = True

Given that setup, you should be able to print recipes with just
the Ingredients and subRecipes listed... (*see Tip below)
Spaghetti
Salt
Water
Meat Balls
Spaghetti Sauce
etc.....

or with subRecipe "detail"

Spaghetti
Salt
Water
Meat Balls
Hamburger
Onion
etc....
Spaghetti Sauce
Tomatoes
etc....

*Tip: Given... that each Ingredient subform record should not have both
an Ingredient and a SubRecipe, you can reassemble both the Ingredients and
SubRecipes into one column for your reports. In a query behind your
report...
SomeName : =NZ([Ingredient],[SubRecipe].[Value])

Can't say as I've ever had to do this, but I'm pretty sure my setup
should work.
 >> Stay informed about: how to catalog recipes 
Back to top
Login to vote
Tom

External


Since: Jan 7, 2009
Posts: 2



(Msg. 5) Posted: Mon Jan 26, 2009 12:50 pm
Post subject: Re: how to catalog recipes
Archived from groups: per prev. post (more info?)
What you are describing here is a bill of materials (BOM) - if you do
a search either in the news group or in general on those terms you
will get some ideas on how to proceed.

I have not had the opportunity to work with BOM database
structures...however, my understanding is that it is not a trivial
undertaking...

Good luck

Tom
 >> Stay informed about: how to catalog recipes 
Back to top
Login to vote
hor vannara

External


Since: Jan 27, 2009
Posts: 6



(Msg. 6) Posted: Tue Jan 27, 2009 3:25 pm
Post subject: Re: how to catalog recipes
Archived from groups: per prev. post (more info?)
"Tom" a écrit dans le message de

> What you are describing here is a bill of materials (BOM) - if you do
> a search either in the news group or in general on those terms you
> will get some ideas on how to proceed.
>
> I have not had the opportunity to work with BOM database
> structures...however, my understanding is that it is not a trivial
> undertaking...
>
> Good luck
>
> Tom
 >> Stay informed about: how to catalog recipes 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Microsoft Office - Can you update Microsoft office version 2003 to 2007 or do you have to buy the newer version

From access to word - Print - Hello, We open word letter from access with hiperlink code. . . .. . . Application.FollowHyperlink "h:\DRISHOT\" & lettername & ".doc" Is it possible to print the letter instead of open it ? How ? thank you

the setting for this property is too long - Hello. I was running the Access performance option and for some forms and reports there was a message with this: the setting for this property is too long what is this? what should I fix in order to not receive this error. Regards, Marco

Me.Name results in "Invalid procedure call or argument" - I am debugging an Access application written by someone else. In Access 2003 it behaves OK, but the client needs to upgrade to Access 2007 for various reasons. When the app is run in Access 2007 I get a few niggles that I have been working through, but..

converting row into column - I have a table with doctors' information Their addresses are linsted in differnt rows i would like to create a row off addresses with one unique record.
   Windows Help (Home) -> Microsoft Access All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]