I asked a similar question a week or so ago and thought I had a solution, but it's only about 75% there so...
I have a form with contact info at the top (say 10 fields) and then it asks for participant info (name, email, gender,a ge, grade completed), for up to X (currently hardcoded at 25) participants. I want to write to one table the top 10 form fields and return an ID (done, no problem) and then post the repeating info to another table with the ID from the first post. The problem that I keep running up against is how to cycle thru each 'set' of participant data? Each participant has 5 pieces of data and I want to loop thru each group or set of data so I post Particpant1 data, then post Participant2 data etc. And then I want to stop trying to post as soon as I hit a blank field. I'm open to creating the participant fields on the fly (so there are only as many as needed and therefore don't have to worry about a blank field), but I am more of a server side backend code kind of a guy. Anybody out here got any great ideas for me?
Any help you can give would be greatly appreciated.
Willie
I have a form with contact info at the top (say 10 fields) and then it asks for participant info (name, email, gender,a ge, grade completed), for up to X (currently hardcoded at 25) participants. I want to write to one table the top 10 form fields and return an ID (done, no problem) and then post the repeating info to another table with the ID from the first post. The problem that I keep running up against is how to cycle thru each 'set' of participant data? Each participant has 5 pieces of data and I want to loop thru each group or set of data so I post Particpant1 data, then post Participant2 data etc. And then I want to stop trying to post as soon as I hit a blank field. I'm open to creating the participant fields on the fly (so there are only as many as needed and therefore don't have to worry about a blank field), but I am more of a server side backend code kind of a guy. Anybody out here got any great ideas for me?
Any help you can give would be greatly appreciated.
Willie
