Dear all
I am having a problem with a form that populates names from a SQL data source. The problem is the names in the list are sorted totally randomly, this would not be a problem if they were also not jumbled up every time the form is reloaded.
Please see the pictures below for clarity
The names do match up with the surnames so I have that going for me. But the trouble is the drop down choices on the right are supposed to align with the names. They do remain in place but again the names change place.
What I have tried so far.
1. Sorting A-Z via surname in the Data connection
2. Changing the way InfoPath sends confirmation as an attachment rather than a live view.
Any suggestions would be greatly appreciated.
Thanks