InfoPath Dev

I have a Infopath form which I have three drop downs I am pulling from a Sharepoint list.  The drop downs are Client, Project, Task.  On my Sharepoint site, the list also includes a column for UserName, which I have added users which are working at a particular client and on that project or task.  On my Infopath form, when the user opens the form, I would like for the Client, Projects, and Tasks that are associated with the user name to be displayed.  But, if that user name is not on that Client, that it doesn't appear on the form. 

 Is there a way to do this?  I am new to Infopath.  Any help would be appreciated. 

 Here is an example of my Sharepoint list

Thanks, Stephanie

Hi Stephanie.

You need to be able to identify the user of your form, and get their full name and other details.

You should check out the AD Web Service from http://www.qdabra.com

With it you can identify your form user and get their name, email address, even group membership and use that to filter your list.

I would recommend a seperator of some kind in your list of names or multiple column fields since it will be dificult to parse a text field with multiple names.

You may be interested in the Database Accelerator package. Qdabra Database Accelerator Suite Version 2.1 - Developer  It includes the AD web service and many others.  It has a whole suite of form templates for project management that you may be interested in.

Or you may just want to see a demo of how we use it.  Let me know.