It is many years since I last touched Access97 but this is the version i
have been given to work with.
I am trying to set up a nutrition database for
use by children in a school to check calorific intake.
I have created two tables one is called tblMeal and the
other is called tblIngredient.


tblIngredient consists of two fields
1 Ingredient which is a text field containing name of ingredient (primary
key)
2 Calories in 1 gram of the ingredient


tblMeal consists of three fields
1 MealName text field (primary key)
2 Servings byte for how many portions
3 Description text/memo


I then created a third table by defining a relationship between the existing
tables
which I called tblMealIngredientJoin
This has three fields
MealName Primary key
Ingredient...........Primary key
Quantity ..........byte value of grams of ingredient required.


I then put tablMealIngredientJoin as a table (based on a meal name)
All seems OK so far but the bit I need help with is how do I add another
field to this form which shows total number of Calories for the ingredient
used.


i.e. Quantity x calories in the ingredient.


Any help appreciated. If the structure is wrong any suggestions ver
welcome.

Thank you.