InfoPath Dev

Hi Experts,

Is it possible to use a query like this in infopath form to fetch data from sharepoint list item and display it in repeating table on form:

Query: select top(3) * from <table> where <column> = @ddEmpName

 ddEmpName is a dropdown on form that contains unique employee names filtered from secondary database (SharePoint list).

Any help is much appreciated.

Thanks in advance. 

Hi,

 Yes you can make query to a sharepoint list. To do so, you need to use CAML queries.

Here is a good web site explaining how to use it.

http://sharepointmagazine.net/technical/development/writing-caml-queries-for-retrieving-list-items-from-a-sharepoint-list

 Hope that helps