K
Katalia369
I have literally hundreds of recipes inherited from my great-grandmother that
I am trying to put in a database so I don't always have to lug out the next
to historic books and risk damaging them(she was 98 when she passed away). I
made one table with no errors and a form both of which seem to be working
great. I am entering the recipes as I go. The trick is now that I have
roughly 280 and odd recipes entered and more to go I was hoping to make a
search window to make it easier to hunt down the one I want. I have 20
ingredient fields labeled "Ingredient #1" - "Ingredient #20" and a required
entry on field one because every recipe must have at least one ingredient.
What I want to do is be able to enter an ingredient (example: Pork) and have
the database search out a list of all the recipes that have pork in them and
display the recipe name (which is unique and the key field) and the one
sentence description I have tagged on each one. Maybe even add the ability to
search by type as I have my recipes divided in a drop down menu to catagories
like "appetizers", "sauces", Main dish" and so on. How do I create this
window so that all I have to do is enter the search and not always have to
keep rebuilding the same query over and over. Something a little more
permenant that anyone can click and find so my kids and later grandkids can
use this too.
I tried reading the tutorials but they all deal with multiple tables and
relationships and extra stuff that mixed in with learning queries just
confuses me. I only have one table and no relationships, but 20 ingredient
fields to search through and a fairly large list of records.
Hope this isn't too hard or too long winded.
Thank You in advance for any replies
A. Hardwick
I am trying to put in a database so I don't always have to lug out the next
to historic books and risk damaging them(she was 98 when she passed away). I
made one table with no errors and a form both of which seem to be working
great. I am entering the recipes as I go. The trick is now that I have
roughly 280 and odd recipes entered and more to go I was hoping to make a
search window to make it easier to hunt down the one I want. I have 20
ingredient fields labeled "Ingredient #1" - "Ingredient #20" and a required
entry on field one because every recipe must have at least one ingredient.
What I want to do is be able to enter an ingredient (example: Pork) and have
the database search out a list of all the recipes that have pork in them and
display the recipe name (which is unique and the key field) and the one
sentence description I have tagged on each one. Maybe even add the ability to
search by type as I have my recipes divided in a drop down menu to catagories
like "appetizers", "sauces", Main dish" and so on. How do I create this
window so that all I have to do is enter the search and not always have to
keep rebuilding the same query over and over. Something a little more
permenant that anyone can click and find so my kids and later grandkids can
use this too.
I tried reading the tutorials but they all deal with multiple tables and
relationships and extra stuff that mixed in with learning queries just
confuses me. I only have one table and no relationships, but 20 ingredient
fields to search through and a fairly large list of records.
Hope this isn't too hard or too long winded.
Thank You in advance for any replies
A. Hardwick