InfoPath Dev

I currently have a form for a new item request. The Item number is a drop down list which is populated by a secondary data source which happens to be an access database table. The table has 8,962 items in it. The other fields that I am trying to populate depending on the choice of the drop down list are Item description, suggested sell price. I found an example that told me to set the drop down list to get it's information from the secondary data source. This works great! Also this example told me to create a rule for this drop down that would set the value of my other filed. I created the rule by setting the action to "set fields value" from a field in the main data source, then click the formula button behind the "value field" and on the "insert formula" click "inser field or group" and select the field from the secondary data source, then click filter. on the filter dialog box i chose "add" and on the specifiy condistions selected "ID" from the drop down list box and left the second drop down list set to "=" and on the third drop down list bos i chose "select field or group" which was of course my "item number in the main data source.

So here lies the problem. When i preview the form, i select an item from my drop down list (which is sorted by item number) and then my "item description filed" is popultaed based on the drop down list. However if i scroll down my item number list to a number which is further down the list and select it, the item description remains blank. How come it will populate let's say the first 100 numbers of the drop down list but not any item further down the list.

I can provide the files if someone can help But i could not attach  them because they exceed the "128 KB" limit.

So you are saying on a new blank form, the first time you use the drop down control, if you scroll down to far then it does not work.  However if you use one of the first one hundred the first time you open the form it does work?  Or is this happening when you try to use the dropdown a second time?

Are you able to scroll through all 8962 item numbers in your drop down? It may have to do with the performance on the drop down this would be a pretty big list, especially if it includes description and price.  Is your main data source an Access Query too?

If you want to reduce the number or items you could look at the Database Accelerator and Web services. Qdabra Database Accelerator Suite Version 2.1 - Developer With DBXL you could query your list so that you could load a shorter list of items.

If these increase numerically it may have something to do with the number of characters. 

I would first rule out that it is not an issue where the items are blank or their is a data issue.  I would create another view and drag the secondary data connection on to it so that you can see all of the data the drop down is using to verify it is not a data issue. Another thing is to add another action to your dropdown which is a message or expression with the values that will pop up so you know it is triggering.

Let me know more info and maybe I can help you further.  You could probably attach some screen shots.