InfoPath Dev

Hi all.

I was wondering if anyone could provide me a solution, or a direction to look in, for the folowing problem:

I have two dropdown lists on my infopath form. 1 for employees, and 1 for departments.

In my sharepoint site I have two according lists.

Now, when I select a department in my form, I want the values in the employee list to be filtered, so it only has the employees from the selected department in it.

This works easily with filtering, but that doesn't work in Web-enabled forms, which IS a requirement ...

Any other possibilities to solve this?

Thanks,
Nick

Nick,

Welcome to our forum! Unfortunately there are some limitations in InfoPath browser forms in the first release. Filtering is one of them. The following article from MS explains workarounds in the best detail:

http://blogs.msdn.com/infopath/archive/2006/10/12/cascading-dropdowns-in-browser-forms.aspx

Shiraz,

Thank you for the article! This really helped me out :)
I don't use SQL to retrieve the data, but it did get me started on resolving the issue.

Thanks again.

Nick

Nick -
If you have not resolved, reply back and I will provide the solution.
I struggled thru this last week and finally managed to get it with the help of greg collins.
greg