InfoPath Dev

Hi YK,

I am lost with what you are trying to achieve here. I created the select field so that I would be able to select an Item to update, since on your previous post there is a record for John with the Age of 23, and you want to update John's age to 24. I'm not understanding how you want it updated without using the current ID of the existing data for updating the record, and instead submit new data.

I am attaching the FormLogic file is an xml I created so that the items in the main datasource wouldn't have unnecessary fields.

As for the CAML, I assumed that you already had it working on your form since you are already attempting to update items.

Going back to the issue, are you trying to copy data from one repeating table to another?

Regards,

Hi,

No. That's not what I am after. No repeating tables.

I have a list (say "Members") with its customized form.

What I want to achieve is the following:

Whenever I update (save) data using this "Members" form, I want a new record to be written to a DIFFERENT list (say "History") with data identical to the data saved to "Members".

The idea is to track all changes made in the "Members" list in the "History" list

I worked around it by introducing a hyperlink which opened a new form (http://sp1...../Lists/History/Newform.aspx?ID=) and passed parameters to it which were used to initialize all its fields (no code used).

Then, the user had to press "Save" in this newly opened History form to save the data and create a new History record.

I want the same effect - create a History record for every save of a "Members" form - but without user intervention at all.

Regards,

YK

.  

Hi YK,

Thank you for clarifying the issue. The issue here may perhaps be with your CAML set up, but since I'm not sur how you have it set up, I am unable to directly pinpoint what is causing the problem. So I am instead attaching a modified form which submits data from one list to another.

Hope this helps.

Hi Don,

I have not set any CAML, I just asked advice on how to perform what I thought a simple task.

The form you sent me is customized to a specic site and I could not do much with it.

If you can explain or point me to an article which explains how to publish to another list I would be much obliged.

If not.. you did give it a try and I thank you for that.

Regards,

YK

HI YK,

From your initial post, I assumed that you have successfully followed the steps on how to create a CAML mapping:

http://www.infopathdev.com/blogs/matt/archive/2006/02/02/Add-SharePoint-List-Items-with-InfoPath.aspx

The approach above should be to help you submit your data to any specific list. You just need indicate the GUID of the SharePoint list where you wish to submit your items to. I'm not sure if publishing a custom form to different list is possible, but you could also check other techniques aside from CAML.