sorting drop down from data source

[Art]

I have finally figured out how to bind a drop down to a data source (SQL
Table).

However, as new records are added to the SQL table, any sense of order is
lost.

Is there any way to tell InfoPath to sort the dropdown alphabetically?

 

[Art]

never mind

Found the solution by modifying the data connection SQL statement adding an
order by statement.