InfoPath Dev

I have two dropdown fields in both lookup to a sharepoint list. I would like the first field lookup the list by company order while aonther field should lookup the list by ticker code. I created two views (one is sorted by company and one is sorted by ticker) in the sharepoint list. However, when I created data connection in infopath, I only can link to the sharepoint list, not to a sharepoint view. So I cannot have different sort for each field. (I can do this in SQL with "ORDER BY" clause).

Please advice if there is any solution for my problem. Thank you :)

well i think you can use code to do the same, you can write object code to fetch the requiered data from sharepoint in sorted manner and then populate the dropdowns using code.

Thank you for your response. Would you please give me more detail on how to accomplish this, such as where I should put the code in. I am new in infopath and this is my first infopath application.

you need to write this code on Loading event. go to tools -> programming -> loadind event and write the code there