InfoPath Dev

How to filter data in drop-down list. In data connection I create query to database (Tools -> Data connections):

Select * from pracownicy where login = '../my.login'

This data i want display data in drop down list 

This example work wrong. Haw resolwe this problem

This unfortunately is not possible with secondary database-type data connections. You cannot use a form value in the SQL statement.  To be able to query secondary data connections the solution is a web service.

If you want one that is installable and ready to go try the Database Accelerator and look at the tutorials.  It also includes an Active Directory web service for queries to AD. Qdabra Database Accelerator Suite Version 2.1 - Developer

Hi clay not 100% true :) please have a look on my post to the other question asked by Monkey which was more or less the same than this one here. http://www.infopathdev.com/forums/t/6765.aspx 

Excellent Trick!

Very Cool - Thanks for sharing that.