Workout Database, how should I handle sets/reps

[dlkingace]

I am in the beginning stages of creating a workout database using access. I have created a table labeled "Body Parts" that has all the various body parts I wish to log in my workouts. I have also created a table for each individual body part with a list of exercises for each table. Lastly, I am in the process of creating some sort of "Schedule" table. Here is where I need some recommendations/help. I plan the schedule to start off with a Date field that will log the day's date in which I worked out. After that I would like to have the following.
-4 fields for body part worked out (I can't imagine ever doing more than 4 in a day)
-6 fields per body part for weight and reps
For example, lets say I worked out my Chest, I would want the table set up something like this, (so I could display it later nicely in a form.)

Body Part: Chest
Exercise1: Bench Press
E1S1W: 100 E1S1R: 14
E1S2W: 110 E1S2R: 12

My question is, I can't imagine doing more than 4 body parts in a session, nor could I imagine doing more than 6 sets per exercise. (And 4 exercises per body part). So, should I have blank fields there ready for data, or is there a way to create some sort of array that I could add how many exercises per body part that I do? I'm just trying to figure out how I should set this table to accomodate all I could ever need at the maximum standards. What do you guys reccomend? If this doesn't make sense and you need me to clarify anything please let me know.

 

[WayneRyan]

dl,

When making your tables, never repeat a field. Break it out into another
table.

Do not use ... Part1, Part2, Part3, etc.

This leads to big trouble later when you search through them. You end
up saying:

If Part1 = "Something" or Part2 = "Something" Or Part3 = "Something" ...

Not fun at all.

tblBodyParts
=========
PartID - Autonumber
PartName

tblExercise
========
ExerciseID - AutoNumber
ExerciseName
Instructions

tblSession
========
SessionID - AutoNumber
SessionDate
ExerciseID
Weight
Reps

Then you have the flexibility of having as many body parts as you want.
As many exercises as you want. And as many sessions as you want.
You're not limited.

You can even modify the structure to track several people.

Wayne

 

[witweew]

a workout schedule

yea, for workout music, you basically need hard-hitting euro-dance music.... nothing else does the job really. Search around on iTunes for "euro club hits" or check this link:

http://phobos.apple.com/WebObjects/...edSearchResults?albumTerm=Euro+Club+Hits+Vol+