General

Re: Lookup to a sharepoint list with different sorts

Qazi Anis — Mon, 01 Feb 2010 05:36:05 GMT

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

Re: Lookup to a sharepoint list with different sorts

eg10013 — Thu, 28 Jan 2010 22:22:31 GMT

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.

Re: Lookup to a sharepoint list with different sorts

Qazi Anis — Thu, 28 Jan 2010 05:37:33 GMT

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.

Lookup to a sharepoint list with different sorts

eg10013 — Wed, 27 Jan 2010 20:57:37 GMT

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 :)