InfoPath Dev

That worked Hilary!  Thank you very much.

Ok, I have gone through the manual, deployed the form as an Admin, added the "Always" check.. and made some progress but not enough. Now when I make a modification to my VendorNumber field that kicks off the data refresh, Success is set to false and Error is set to "failed to execute query". I have confirmed that qRules are ...

You are, of course, correct (not about me being smart).  I should be using a vendor list with unique names and disallowing manual entry on forms.  I was really just trying to see what your control was capable of and unique filtering would have been a nice touch. That said, when I deployed the form to my server, the FilterOwssvr code ...

Thanks so much!  That worked. Now that I'm burning through my obstacles, which of your documents should I read to find out how to retrieve a distinct list of Vendors from the existing SP List to make them available in a drop down?  I don't want to bring back all rows and then exlude duplicates because in future this list will ...

Another quick question while I'm at it.  I would now like to create a filter not just on the Invoice Number but also the Vendor Name.  What does that syntax look like given my existing value looks like this:concat("FilterOwssvr /dsname=FilterOwssvr /filter=Invoice_x0020_Number /value=", .)I have tried the following but ...

Genius!  That did the trick.  Many thanks!

Thanks to both of you for replying so quickly!  I have not re-injected my form yet.  I did however put the command, result, success, error boxes on the form.  When I type in GenerateGuid, I get a valid GUID in the result box and true in the Success box.  When I type in concat, I get "Invalid command specified: ...

Hello, I'm trying out qRules for the first time to see if it will do the trick for us.  I have a text box (Invoice Number) on an InfoPath form.  After being filled, I would like to display all other invoices in the same library with the same Invoice Number in a repeating table below.  I have followed the example ...