InfoPath Dev

Sure, you could. I wouldn't - but I'm guessing you were posting this as I was posting my reply.

It looks like I can set a query field, query the DS2 and then set a different query field and query again - further refining the data. So after getting the Site-A records set DS2 query field "ID" to DS2 data field max(ID), getting the latest of the site-A entrees - does that sound right?

So - the most recent row is the first one. In InfoPath, if we select a field from a repeating data source, it is by default going to return the first value - that's why I had you sort desc. :-) You can also just index the XPath if need be - select the field using the field picker, in the formula editor tick the box to show the XPath and put ...

OK,I dragged the new connection (to the same [main] list) fields onto the form in a repeating table, with a query field and a query button and all works, sorted by Modified desc. However it produces duplicate rows for the same site (since multiple exist). How do I get just the MOST RECENT row, from Site-A?

Yes, if I can populate from the same list, without using a second one, that will be best. In my trial I wasn't able to get any data with simple rules. I'll try using the query fields, which I'm just beginning to understand. Where would I set to sort by Modified desc, in the all items view?

 Hi, Hilary! Thank you for your reply. Here are two link code examples that work in IE compatibility mode and Edge compatibility mode.  Example 1  <!-- Create a new InfoPath document from a web page -->  <script language="vbscript">  ' Set the URL to the form Library.   ' Note ...

No. You will not be able to update one list from another list form using out of the box InfoPath and SharePoint List functionality. I may have misunderstood your question. I thought you were asking if you could populate the form with the most recent saved values.

In the direct link, do you include any URL params, like maybe "openin" or "noredirect"? I'm wondering if those might help here. https://docs.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/ms772417(v%3Doffice.14)

Thanks for the quick reply! This SharePoint 2019 seems to be quite a challenge. Since direct linking to the InfoPath form isn't working, I thought maybe my work around could be to filter the Form list on a unique value using FilterField1 and FilterValue1 in the URL - of course it appears in 2019 that doesn't work either and requires some ...

That's terrible!  I'm sorry you're going through that issue.  Background on what I know from my testing at this point is it's complicated....We are working to get off of Internet Explorer in Compatibility Mode as fast as possible due to security issues with IE.  IE still works for me with ...