I have an issue, in my infopath form, there is a dataconnection that receives data from SQL server and fills up a drop down. I have converted that data connection to data connection file (.udcx) as a relative link to site collection. This data connection is refered at many locations in form.
My question is: Is there a way where I can modify query in this data connection file and that change is reflected wherever this data connection is refered? I just want to add "order by" clause in the query so that data in drop down is in alphabetical order.
Any help will be much appreciated.
Thanks in advance.