Drop-down list out of order

[CoryP]

I developed an infopath form (sp1) for a client last summer and all has been
working good until recently. At random times, the dropdown box on the form
is completely out of order. There are thousands of values in it, so it is
very hard to find what you want if there is no logical order to it.

This dropdown box is populated by pulling data in from a SQL database. I
have tried adding an 'order by' clause to the sql statement on the dropdown,
but that did not seem to have any affect.

The client has said that this has happened a few times before, but it always
seemed to fix itself somehow. So far, the dropdown box has been out of order
going on 5 hours today.

If you have any idea why this would be happening or how I might go about
fixing this issue, please let me know ASAP! The client can not complete some
of their day-to-day tasks because of this.

Thanks,
Cory

 

[CoryP]

The table that the item data is being pulled from to populate the database
does not have a primary key set. And I am pretty sure that there was a
primary key set in the past. Could this be the problem?

 

[Adam Harding]

Yep

Not having a Primary renders Infopath on shaky ground when trying to
understand the data and the order it is in.

Not had this problem myself but Infopath does not like data connections
without primary keys at all.

Cheers Adam