Steps Taken
Hi - thanks for looking into this.
1. I tried the previous suggestions of deleting the file and changing the 1 to a -1 which did not work.
2. I followed the steps of the tutorial by:
a. creating form
b. creating record set for both the table to update (rsBOOK) and the dynamic menu/list (rsCOACHES)
c. created take to hold values - added text field for COACH_ID
d. created repeat region
e. in server behaviors, did the data assist multiple update records wizard.
THIS WORKED FINE (any changed row record updated perfectly)
f. then created new page and repeated above but....
g. instead of the text field, created a dynamic list menu from the rsCOACHES binding the COACH_ID to the rsBOOK COACH_ID field.
h. in testing page - the list menu is displaying correct "coach name" but on updating, only THE LAST ROW actually updates.
I am a newbie but can only assume it has something to do the the counter on the list menu not working? Any guidance would be great. Is there some "working code" with the use of a list menu that you could post that I could compare?