InfoPath Dev

And, I guess, if the second approver rejects it - does the Form Status get set to Rejected? or something else, like "second approver rejected".... since if it is anything except Rejected or Completed, that email is going to send to next approver....

I guess the first thing I'd check (I'm sure you've done this) is that the Form Status field is the value I expect.... So, I'd probably download the actual XML from the library, and open it in a text editor for this. The Form Status field isn't repeating or anything, is it?

Now you see what I was trying to explain. :) So - go look at the rule on the button - I added one rule. It sets the query field in your data connection to the product type that you entered. Then, when the query runs, only the matches are returned. Now, you will need to handle for the case where no matches are returned. Want me to set up the rules ...

Ok. Did you try entering one of those values (01, 02, etc) in the Product Type field and clicking the button? Do you have any forms submitted in your library?

In your latest form, field18 is the product number, so in that case in your "Get Product Number" rules, you'd set the query field18 in the Teklif No Form to the selected Product Number. I've added that rule to this form, just in case I've guessed correctly. Save the file locally, right click and preview. Enter an existing ...

Yes. The top section.

Ick. I found this: https://www.infopathdev.com/forums/p/25654/89011.aspx which suggested https://blogs.msdn.microsoft.com/besidethepoint/2010/05/08/double-hop-authentication-why-ntlm-fails-and-kerberos-works/. I know nothing about kerberos (well, I once worked with someone who named their dog that - but that's all I've got) - but perhaps ...

Here's a simplified sample of the filter you need on the dropdown - you'll need to have a data connection to list 2 in the form (so you know what all has been used) then on your dropdown you can add a simple field from list 1 = field from list 2 filter and wrap it in a not(). Save the attached file locally, right click and select design, ...

When you publish the form to SharePoint (not quick publish, but walk through the publish wizard) you can select columns to promote to your library.

So - can you change the control on your form from a text box to a calculated value? That should allow formatting. :)