How to input ingredients into a table.

[AcousticBruce]

In a table I need to store ingredients with a unit and an amount. Some recipes will have 3 ingredients, some will have 17. So it would be nice if the ingredients can go in to one column. How would I go about adding this to a table? A name is simple because it is one cell and will always be one cell. An ingredient however, is any number of different inputs. So would each ingredient add a new field or is there a way to get all that information using only 1 field?



I need all this stored.

Simple Blueberry Muffin recipe.

# | Unit | Ingredient
--------------------------------
6 - Tbsp - Unsalted Butter
¾ - cup - Sugar
2 - count - Eggs
½ - Cup - Sour Cream
1 - tsp - Vanilla Extract
½ - tsp - Orange Zest
1¼ - cup - Self-Rising Flour
1 - cup - Fresh Blueberries

[burrina]

Not sure how you have your db structured. Here is a pic of a Recipe db with basic relationships.


HTH

[AcousticBruce]

I do not have one made yet. I was going to start typing in a recipe then create a form that will input them in. I do not understand relationships or what I am looking at yet. I guess it will be a slow process. So for right now, how would I add ingredients to a table? I need to be able to calculate them and create a shopping list separated by type of produce.

The only recipe database I can find as a template is NOT detailed enough. I would rather start from scretch.

[ItsMe]

You will need to understand what a relational database is before you can create tables. You will need to understand how to create tables before you can create queries. You will need to understand how to create queries before you can create forms and or reports. You will need forms and or reports to manage the data in your tables.

Here is a very brief intro to relational databases. Access is an RDBMS. Access also offers a way for developers to create user interfaces (GUI) to Retrieve, Edit, Append, and Delete data.
http://www.r937.com/Relational.html

[AcousticBruce]

Thanks ItsMe. Why not give me a call and I pay you with paypal. I just want to have a conversation about how this works with a 1 on 1 specialist. Ill pay you for your time. I am serious. I will read that entire page you put a link for.

[ItsMe]

I am not currently able to receive compensation for services. However, I will send you a PM.