Re: Multiple tables on a tabcontrol form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Gary,

Once you have that schema (or something similar), you can create a main form
for, say, Sessions, and subforms for the rest, linking on SessionID. In this
way, moving from Session to Session, you can see all the Sets involved in
each Session.

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia
---------------------------

"GaryD" <GaryD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ED072464-3D75-4BA8-A8B4-482988B5D59C@xxxxxxxxxxxxxxxx
wow, ok! Thanks very very much. I really appreciate the time you took to
do
this. I will give it a shot.

"Graham R Seach" wrote:

Gary,

tblSession
* SessionID (AutoNumber - Primary Key)
SessionDate (DateTime)
Other info, as required

tblSet
* SetID (AutoNumber - Primary Key)
SessionID (Long Integer - Foreign Key to tblSession.SessionID)
ExerciseID (Long Integer - Foreign Key to tblExercise.ExerciseID)
Repetitions (Integer)
Weight (Single)

tblExercise
* ExerciseID (Autonumber - Primary Key)
MuscleGroup (Text)
Other info, as required

The relationships are as follows:
* tblSession.SessionID --> tblSet.SessionID = One to Many
* tblExercise.ExerciseID --> tblSet.ExerciseID = One to Many

With this architecture (keeping in mind, I don't know everything you need
to
record), you can record many exercises, and use them as *templates* for
many
sets/sessions. You can record many sets per session, as well as many
sessions.

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia
---------------------------

"GaryD" <GaryD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7F2CD942-B912-41FD-AA1F-8A3656E1DC12@xxxxxxxxxxxxxxxx
Thanks Graham for the rapid reply and for the link. Let me present one
example of how the table got so big and maybe you could explain what im
not
quite getting. Lets say im creating a table to keep record of
weightlifting
sessions. I have a muscle group, a exercise, and lets say 4 sets.
Each
set
has reps and weight. Now I move on to another exercise in the same
muscle
group. Now I have on in the table a separate field for each exercise
and
group, weight and reps... not sets I label the rows on the form. So as
you
can imagine I will fill up many fields very fast with 16 exercises on
the
screen. Should I be creating one field for one complete set? What Im
trying
to do is have a spreadsheet look so you could lets say see your whole
muscle
groupe on the screen while exercising. Is this even close or am I way
off?
And again thanks for the help.

"Graham R Seach" wrote:

Gary,

I'm afraid if you have 255 fields in the one table, then your table
design
needs to be re-thought. Many of the fields in that table should, in
fact,
be
in other tables.

See the following for more information:
http://en.wikipedia.org/wiki/Database_normalization

Also search the Internet for "normalization".

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia
---------------------------

"GaryD" <GaryD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A0920DF1-80C4-4E05-A886-BD093C82F1DD@xxxxxxxxxxxxxxxx
Im not sure of verbage for this so forgive me. But I have created a
tabcontrol form from scratch. During the creation it askes for a
table
to
use, no problem. But now I have filled the table with 255 fields.
So
my
dilema is adding more fields, I see that subforms may be the only
answer.
But I cant seem to find if its possible to open another separate
table
to
keep the original table smaller. Is the subform option the answer?
Can
I
open/import/add another table? Thanks for your help in advance.








.

Relevant Pages

  • Re: Wow, liver dump R me!
    ... End of first session, 5.1; ate half a Kit-kat, I think the whole is ... Supper, chili con carne with black soy beans, 1/2 slice plastic bread ... I'm back to morning exercise causing dumps - extreme morning ... Maybe they could be the carby gift that keeps ...
    (alt.support.diabetes)
  • Re: Multiple tables on a tabcontrol form
    ... "Graham R Seach" wrote: ... for, say, Sessions, and subforms for the rest, linking on SessionID. ... way, moving from Session to Session, you can see all the Sets involved in ... I have a muscle group, a exercise, and lets say 4 sets. ...
    (microsoft.public.access.forms)
  • Re: Neep some comments on my schema...
    ... It's basically a form that logs several people's workout ... > session on a regular basis...so every form is one workout log for one ... > EXERCISE ... you can use roughly the same structure to store the SessionPlan (you ...
    (comp.databases.theory)
  • Eating low carb after exercise best for improving insulin sensitivity even without weight loss
    ... What you eat after exercise matters ... This study follows up on several previous studies that demonstrate that many health benefits of exercise are transient: one exercise session produces benefits to the body that taper off, generally within hours or a few days. ... Interestingly, when the research subjects in this study ate relatively low-calorie meals after exercise, this did not improve insulin sensitivity any more than when they ate enough calories to match what they expended during exercise. ... The American Physiological Society ...
    (alt.support.diabetes)
  • Re: Exercise Day in a.s.d
    ... but I try to put in exercise 5 days every ... My usual session is a random flat to 8% grade. ... 45 minutes of Yoga. ... and it really helps my balance which helps my golf swing. ...
    (alt.support.diabetes)