Im having trouble finding the most efficient way put this database together which is designed to output a weight lifting workout from a database the desired output is a page with the users name, and lines that include(lift name, set,reps,weight(by percentage); sets, reps, weight) example
joe schmoe
02/24/2004
snatch (2x3[200lbs]) || (3x2[210lbs]) || (1x1[220lbs])
benchpress (3x5[300lbs]) || (2x2[320lbs])
" "
" "
ignore formating its just: lift (set x rep[calculated weight]) ||......
and each set has an id and multiplier which is how many sets per (set)
heres a rough and incomplete design I have drawn up but it seams like too much space would be taken by the sets/reps/percentage
would it be ok to just put set/rep/percentage in one field??
here
if it doesnt work copy and paste into addressbar
http://www.geocities.com/eatsleepthrow/firstdraftincomplete.gif
thanks for any help
