Hi guys, I'm a little stuck with a project that maybe one of you could help me with.
Here goes:
(-< = one to many)
(NA= No textbox available)
I have Three tables (Workout table -< WorkoutItems -< WorkoutItemValues
I build a dynamic form from memory, so it could look like this on an .aspx table
Workout Name: Upper Body
Exercise Name |Set Number | Pounds |Reps |Time
Arm curls |1 | 95 |10 |NA
Arm curls |2 | 95 |10 |NA
Arm curls |3 | 95 |10 |NA
Treadmill |1 | NA |NA |20:00
Here is the PROBLEM
I want to be able to iterate through this "form of workout item values" and apply the changes in memory only. It would be much MUCH easier to save this to the database first and just dump the changes to the database, but I want to do this in memory. I am not able to reference each created textbox in the table like this ( TextBoxName.ID = myWorkoutItemValue.ID), so for now I am referencing each textbox I create in the controls collection of the form like this NameOfTextBox.ID = RowIndexNumberHere & ":" & ColumnIndexHere, I then match up the values accordingly. This seems like a ton of work and there is possibly a much better way of doing this. So essentially I just want this:
To be able to create a new workout with exercises in it, build a form displaying the workout with textboxes and labels. When the user hits save, save the entire form to the database. If the user builds a new workout and hits cancel, then just never write the form to the database in the first place.
Thanks so much to whoever can help me out!!
jaxon
