Basic Table Relationships

J

Jodstar

This is a basic question. I haven't been working in Access for over two years
so my memory is a bit shot...

I have three tables:
Breaktotaltbl
Lunchtotaltbl
Dintotaltbl

Each has information regarding that specific meal which is then calculated
into four total values for each record.
I would like those four values (b1, b2, b3, b4; l1, l2, l3, l4; d1, d2, d3,
d4) to all be placed into a daily chart that includes b1+l1+d1; b2+l2+d2...
etc.

I have tried to make relationships however the main table (MainFoodtbl) does
not update when I update the three individual tables. What should I be doing?
 
R

robo

Hello,

Could I see your tables, fields, PK and FK's. It will be easier for me to
understand what you are trying to do.

Thanks
 
J

Jodstar

"See"? I'm not sure what you mean by this... :) Sorry. I will give you the
names of the fields, maybe that's what you were looking for?

Table;
Fields;
PK/FK

BreakTotaltbl;
BCal, BFat, BCarb, BProtein
Date: FK

LunchTotaltbl;
LCal, LFat, LCarb, LProtein
Date: FK

DinTotaltbl;
DCal, DFat, DCarb, DProtein
Date: FK

MasterFood;
BCal, BFat, BCarb, BProtein
LCal, LFat, LCarb, LProtein
DCal, DFat, DCarb, DProtein
Date: PK

there are other tables including LunchTotaltbl and DinTotaltbl which
resemble BreakTotaltbl. They all have other, unrelated, fields such as
B1Food; B2Food; B3Food for BreakTotaltbl or L1Food; L2Food; L3Food for
LunchTotaltbl... etc.

What I need to do is link MasterFood by date to the other tables so that i
would be able to pull the information from each individual form into the
master form by date....

Does this make sense?
 
K

KARL DEWEY

Use an append query.

Better would be to have one table like this --
MasterFood;
Cal
Fat
Carb
Protein
Meal:: These two in conjunction to form the primary key
Date::
 
Top