M
Mike
I don't know if this is the right forum to be posting this
in as I didn't see one that seemed to fit my particular
problem. Anyway, I'm trying to build a DB for a workout
routine. The idea seemed simple after the last several
dozen DBs I've built but I'm having a hell of a time
achieving the desired results.
Here's the basics....as an example, say there are 24
unique exercises. These exerceises are broken down into
muscle groups by day, meaning on mondays you workout the
muscle group in the chest, tuesday the back and so on.
Fairly simple right? Well, it gets complicated soon. In
this DB there are up to 18 different workout routines. In
each routine you may only use 16 of those original
24...but the 16 used will not be the same every time. To
add to that, each routine may or may not work the same
muscle group on the same day.
I hope that's not as confusing as it sounds.
Well, I can pretty much build a DB that does the basics of
tracking individual things....routine or day of week
exercised but not both at the same time. What I can't
figure out is how to assign these things to particular
dates based upon a calendar or how to group the exercises
so that I don't have to duplicate entries for each workout
routine and day.
To some of you this may seem simple but I have learned
Access through trial and error without the aid of any
books or classes.
So, if you think you can help please email me. Thanks!
Mike
in as I didn't see one that seemed to fit my particular
problem. Anyway, I'm trying to build a DB for a workout
routine. The idea seemed simple after the last several
dozen DBs I've built but I'm having a hell of a time
achieving the desired results.
Here's the basics....as an example, say there are 24
unique exercises. These exerceises are broken down into
muscle groups by day, meaning on mondays you workout the
muscle group in the chest, tuesday the back and so on.
Fairly simple right? Well, it gets complicated soon. In
this DB there are up to 18 different workout routines. In
each routine you may only use 16 of those original
24...but the 16 used will not be the same every time. To
add to that, each routine may or may not work the same
muscle group on the same day.
I hope that's not as confusing as it sounds.
Well, I can pretty much build a DB that does the basics of
tracking individual things....routine or day of week
exercised but not both at the same time. What I can't
figure out is how to assign these things to particular
dates based upon a calendar or how to group the exercises
so that I don't have to duplicate entries for each workout
routine and day.
To some of you this may seem simple but I have learned
Access through trial and error without the aid of any
books or classes.
So, if you think you can help please email me. Thanks!
Mike