creating/editing multiple records on one form

[jsabol]

Hi,

I'm trying to edit multiple records on a single form in an XSLT template, using a simple loop to display each returned record within the form. The page loads fine, displaying the current data and allowing changes, but then the changes are not saved when I submit the form...

Is it impossible to edit multiple records in one form?

Sorry if this has been addressed already, I did look around for earlier posts but didn't find anything.

Thank you!

Edited September 9, 2005 by Guest

[Martin Brändle]

You can't do that this way. Each record would need its own form, with its own submit button, and its own input fields with which the record id and the field name/value pairs would be submitted. Only one record id can be submitted at once. It was the same with CDML.

But there is a solution.

About five years ago I had posted a CDML solution for editing multiple records to the fmwebtalk list.

I have rewritten this example from scratch in XSLT. See attachment.

The trick is to use a portal, because multiple portal rows can be edited/added at once. See p. 78 of the FMS7A CWP Guide.

In the example, the original separate records are in table A. When they have to be edited, a portal showing the records of A in table B is used. The relation between B and A is made with a cross-operator. Therefore, B needs only to have one single record that specifies the parent record id that must be submitted with the portal data.

Everything else (especially some tricks concerning refreshing the data and relaying back to the start page) are commented in the XSLT files.

test_multiplerecords.zip

[jsabol]

Thank you, Martin! I'll try it today... I had actually tried to work out a way to do this with portals, but couldn't figure it out ... I really appreciate your help!