Fitness Training Form

[DCXtreme]

I'm trying to set up a training program for my gym database but I'm having alot of problems, I will be in debt to anyone who can help me out!

My current "training" tables"

ExAttributes

ExID - PKEY
ExType - (Sets, Reps etc)

ExerciseTypes

ExerciseID - PKEY
TrainingType - (Lookup from TrainingTypes, cardio etc)
ExerciseName - (jogging, swimming etc)

Training

TrainingID - PKEY
MembershipNo - FKEY
TrainingType - (Lookup from TrainingTypes, cardio etc)
ExerciseName - (Lookup from exercisetypes)

TrainingTypes

TypeID - PKEY
TrainingType - (Cardio, Strength etc)

---

Hope that makes things abit clearer

Just to clarify I have most of the other things done, the membership, payment, measurements and health forms are working great, I can also search for members and run queries as to when membership runs out & who hasnt attended in a set period of days.

What I am looking for from this training form is just a form where I can bring up a membership ID, and below that have a series of drop down boxes, one under the heading Cardio and one under the heading Weights. I should be able to select an exercise in one of the many combo boxes (for example jogging) - and then enter the time / distance in text boxes.

I should be able to do the same then with the weights but with sets / reps / weight instead.

I also want to have Sessions 1,2 and 3 for each member ID, as part of the training plan they will have to do 3 sessions a week, these should be able to be different.

Thanks in advance.

 

[DCXtreme]

Thanks, now I just need to figure out how to put this into a form!

 

[DCXtreme]

Thanks SO much for laying the tables out in a way I understand, As I probabbly mentioned I have to have this up and running for the gym on Wednesday!

If I am being rude I apologise but how could I best fit this into a form, or forms.

I've linked below to a rough layout of what I kind of wanted the training form to look like.

I would be forever indebted to you if you could help me out with this! I've been stuck on it for days!

Jon

 

[JoeCruse]

I have set up my own application for exercising, and pretty much agree with Pat. I set up with a main form for the exercise event-subform for exercises performed-subform for sets and repetitions.

I will clean it up one day this week and post it here.

 

[DCXtreme]

Thanks that would be great!

Pat has been a great help but, I hate to say this but I dont think I have the visualisation to get around what he is saying, even though I know it makes perfect sense! It would be great to have a look at a finished example to see how you got to where you did, as the gym opens saturday!

 

[DCXtreme]

Hi there, so thanks to Joe I now have a working (kind of) exercise database, the only problem is that it stores by workoutID and I want it to store by MemberNo, with each member able to have 3 workouts maximum, can anyone help me with this, I have attached a copy of my database for you to look at if that helps, thanks alot for all the help, my gym opens TOMMOROW!

Jon