Would this be possible in Access?

I would like to create a resource of recipies in order that I can use some
yes/no boxes or input boxes to say what ingredients I have in my cupboard and
follow the flow chart idea of ending up with a list of recipies which would
use up my ingredients.

I know a bit of VB, am learning java but know access quite well so I think
this is my safest route to creating something that works. I presume I would
have tables of ingredients (pork, poultry, veb, seasoning...) and then a form
to input what each recipie contains and the amounts of each ingredient.

My question is how would I input what ingredients I actually have, and then
how do I get a query to return results which only contain the ingredients I
have input? I could use a massive form with check boxes but that might be far
too large and user unfriendly. If recipies which use ginger only have beef
then there's no point asking a person who doesn't have the beef whether they
have ginger.

I hope this makes sense and thanks for any advice.

Hi Clare,

I've read your question message over and over for 10 minutes and I can't
paint the picture of the table structure your defining. However, I think your
core question is about SQL and the existance or non-existance of data in a
field. If that is the case, a test for: "WHERE SomeIngredient Null" should
be sufficiant.




"Clare" wrote:

I would like to create a resource of recipies in order that I can use some
yes/no boxes or input boxes to say what ingredients I have in my cupboard and
follow the flow chart idea of ending up with a list of recipies which would
use up my ingredients.

I know a bit of VB, am learning java but know access quite well so I think
this is my safest route to creating something that works. I presume I would
have tables of ingredients (pork, poultry, veb, seasoning...) and then a form
to input what each recipie contains and the amounts of each ingredient.

My question is how would I input what ingredients I actually have, and then
how do I get a query to return results which only contain the ingredients I
have input? I could use a massive form with check boxes but that might be far
too large and user unfriendly. If recipies which use ginger only have beef
then there's no point asking a person who doesn't have the beef whether they
have ginger.

I hope this makes sense and thanks for any advice.

Hi Clare,

I suppose the general idea could be something like this (* indicates a
field is, or is in, the table's primary key):

tblIngredients
IngredientName*
other fields

tblInventory
IngredientName* - FK
DatePurchased*
UseByDate
Unit (e.g. g, ml)
QuantityOnHand
other fields?

tblRecipe
RecipeName*
Description
Instructions
other fields

tblRecipeIngredients
RecipeName* - FK
IngredientName* - FK
Quantity

With a structure along these lines it would be possible to write a query
that returns every recipe that can be made from the ingredients on hand.



On Thu, 6 Jan 2005 01:27:02 -0800, "Clare"
wrote:

I would like to create a resource of recipies in order that I can use some
yes/no boxes or input boxes to say what ingredients I have in my cupboard and
follow the flow chart idea of ending up with a list of recipies which would
use up my ingredients.

I know a bit of VB, am learning java but know access quite well so I think
this is my safest route to creating something that works. I presume I would
have tables of ingredients (pork, poultry, veb, seasoning...) and then a form
to input what each recipie contains and the amounts of each ingredient.

My question is how would I input what ingredients I actually have, and then
how do I get a query to return results which only contain the ingredients I
have input? I could use a massive form with check boxes but that might be far
too large and user unfriendly. If recipies which use ginger only have beef
then there's no point asking a person who doesn't have the beef whether they
have ginger.

I hope this makes sense and thanks for any advice.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

=?Utf-8?B?U3R1YXJ0?= wrote in
:

a test for: "WHERE SomeIngredient Null" should
be sufficient.



Or, rather, WHERE SomeIngredient IS NOT NULL

The expression Something NULL always returns NULL regardless of the
value (or non-value) of Something. NULL is neither equal-to or unequal-to
anything, not even another NULL.

B Wishes


Tim F