InfoPath Dev

I had assistance from QDabra staff yesterday in setting up a form that calculated the difference in value from a meter reading entered today and the reading from yesterday.  The solution pulled in a secondary data source, and set a rule to run after todays meter reading was entered in the form.  The rule checked the last record entered in the sharepoint list (using Max(ID)) and calcuated the value to a field in the primary data source

 After meeting with the departments staff, I found out the value needs to be set on the last record entered of the day before.  So I need to set the value to the last record in the secondary data source, not the primary.

For example:

What would be the best way to go after this?  I tried setting the rule to update the secondary dataset, however no filter could be applied.  I created a Form Load rule to filter the table to the current record, however when I try to set the field, the value shows in the form, but not in the list after the form is submitted.

 Using a sharepoint list - infopath form on Sharepoint 2010

Any suggestions?

Thanks in advance,

Keith

 Hi - out of the box, InfoPath is not going to let you set another list item from your list form. And since this is a list form, you can't add code or qRules to do this either. Are you using Office365? If not, you may be able to use the Lists web service and UpdateListItem method with a CAML query to do this.