InfoPath Dev

oooooooooooooooooooo My Gooooooooooooooooooooooooooooddddddddddddddddddddddddddddddddd !!!!!!!!!!!!!!!!!!!!!! You are unbelievable !!!!!!! How can you do that !!!!! Thank you so so much Thank youuuu :)))) I didn't understand but i will try to understand Thank you Thank you Thank you :))))))))))))

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 for that for you? And you also should be doing this as part of your submit rules (because otherwise, if a few people have the form open at the same time, you could end up with multiple people with the same number) but this at least gets you headed in the right direction.

Hilary thank you so so much. I am really want to you set rules for no matches found. I will appreciate it. I check your rule and i see that ( in attachment) I couldn't understand why you set field to same field ? and why field18 name is Field_x0020_18 ? I cannot figure out.

In the screenshot you posted, see where it says "Field" in the middle input field - there is a field picker button to the right. If you click that, you'll see that the field I am setting is the one in the data connection you created - it is a query field for the data connection. Here's a blog post that may help you: https://wonderlaura.com/2011/08/01/infopath-query-specific-sharepoint-list-data/ I'll set up the other rules later today / tomorrow in the last form I posted and add it to a reply.

Here's a copy of your form w/ a second rule on the button to reset field17 if no data is returned from the query.

Hilary you are the Queen of the Infopath ! :)) this is awesome. I taken 2 pictures. in your form there is a rule "number of occurrences of sharepoint list item". How can you create it? Because i havent that option (picture two is mine)

You need to change the first dropdown to Select a field or group, then navigate to the repeating data source. See attached.

Oh I didn't know that :) Thank you so so much Hilary. This form the best form i have ever seen for me :) You can't imagine how you helped to me. Best Regards