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.