Extremely Basic Question

[November]

Hi all,

Very new to access, and I am stuck.

lBasically what I am trying to create is a simple diet tracking database that lets me create a daily meal plan.

So I have one table with all the foods and their various nutrients

Then I have a table of each day that I can populate from the food table.

My problem is when I create a lookup field for the Day table, I can only get the food name displayed. I can't really seperate all the other values in the to perform totals calculations.

Am I going about this all wrong?

Any help appreciated.

[ranman256]

you have a tFood table, and you will need a tMeal table.
tMeal table has multiple items from tFood. Are you using an ID in tFood? or the Food name?

tMeal DOES need an ID
[id], [MealName]
1, Veggie plate
2, Fried Chicken

but you also need the item list of the tMeal, say tMealItems
this holds all the foods in the meal.
tMealItems
[id],[Food]
1, green beans
1, cauliflower
1, hummus
2, chicken
2, green beans

this tMealItems MUST be put in the realtionship with tMeal.

[CJ_London]

suggest you may also need a table for nutrients and another to link to the foods

tblNutrients
NutrientPK autonumber
NutrientName text
Info text benefits of this nutrient

1..vitaminA......good for
2..vitaminB......good for
3..Fat..............bad for
4..sugar...........bad for


tblMealNutrients
MNPK autonumber
MealFK long - link to meal table
NutrientFK long - link to nutrient table
qty double - quantity per 100g

1..12...1...0.2
2..12...3...0.1
2..12...4...4.5

[ssanfu]

My problem is when I create a lookup field for the Day table,.......

I have NEVER and will NEVER use a look up field in a table. This should be done in a combo box on a form.

[November]

Hi all,

Hmm I am getting more stuck!!!!

So maybe I am going about it the wrong way.

I am trying to create something where I can add meals/foods to a day, which will automatically calculate the totals of those nutrients for that day. E.G Monday Bread Protein 10g Fat 25g Carb 30g

So The tables I have are

tMeals - This includes a description of the food and the nutrients
tDay - This is what day the meals will be added on

Where I am getting stuck is trying to put these in a form, but when I select a Meal, how do I get it to populate the rest of the nutrient fields e.g proten/cabs/fats?

Any help appreciated!