Fitness Training Form

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.