
January 10th, 2005, 09:45 PM
|
|
Registered User
|
|
Join Date: Dec 2004
Location: Wild and Wonderful, West Virginia
Posts: 27
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Multiple tables or just a few?
I was wanting to create a database to keep track of my workout progress.
Basically I want to have a date, then the workouts I did (Bench press, squats, leg press...) with the weight and number of reps.
I'm not sure the most effective way to do this. I think I have to create a new table for each workout and link them by the date?
An example of the data would be...
1/1/05 Benchpress 12 reps @ 145, 10 reps @ 160, 8 reps @ 175
Bicep curl 15 reps @ 45 , 10 reps @ 55, 5 reps @ 70
I'm planning to put this on my PDA, if that matters.
|