Basic Table Relationships

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
"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?
 
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::
 
Back
Top