Editing multiple records using CDML

[danabase]

I have a couple of issues with a hosted database I am trying to write the web interface connection for.

It is part of a Course Request System for high school students. The part I am working on is a way for department heads to enter the eligible courses per student, and then have that list be a custom pop-up, based on each student's eligible courses. E.g, Math Head says Suzie Q can take Trig & pre-calc, but not robotics. Then when suzie q logs on, she only can choose from Trig & pre-calc. Right now I am just getting the basic mechanics working and have a few problems.

The entry page for dept heads works. They find a set of students (11th graders for Math checkboxes). The page displays usingFMP-If's and tokens for the grade and dept combo, so they see the correct stuff. Great.

They see only student1, and can enter her checks and SUBMIT. That's okay, BUT - is there anyway to EDIT a LIST? I can get a list to view, with all the checkboxes, but it's my understanding that -Edit and -RecID can only edit one record at a time. If that is not true, that would be GREAT! But, since I think it is...I have made an alternative, but still need help with that.

Okay, if they submit checks for one student, the reply page brings them back the same found set, and goes to student 2 using a token in an inlineaction. That works fine, it actually looks like the page just refreshed and went to student 2. The problem is that the -edit button does not work there; it says format file not found. I did specify a format file, but if I include -RecID in the inline, it gives me the previous record, and messes up the find and skip. I am guessing that it is because it is all inside an inline action whose action is -find. So...can I have an edit action inside an inline - or am I approaching this the wrong way?

Here is my inline action on my reply page:

[FMP-InlineAction: -db=_EligibleCourses.fp5, -lay=Eligible, -format=reply2.htm, -token.1={CurrentToken.1}, -token.4={CurrentToken.4}+1, -Max=1, -Skip={currenttoken.4}, -SortField=ToScheduler::NameReverse, -SortOrder=Ascending, -Op=eq, ToScheduler::Grade={currenttoken.2}, -find]

So that find works, but then my -edit button does not. ANY clues? Is CDML too simple for this? Thx, in advance!

[surwoop]

You can edit multiple records through a portal, you need to use the 'current portal row number' replacement tag.

e.g.

input type="text" name="relationshipname::fieldname.[fmp-currentportalrownumber]"

Hope this helps.

[Garry Claridge]

The other way is to use PHP.

All the best.

Garry