InfoPath Dev

I have looked throught the different tutorials, but haven't found a solution for my problem so far.

I'm creating a form where our employees are assigned to different workgroups. As part of that I've created a field where one worker at the time is chosen by use of a drop down list box, which displays Employee Name and has the value Employee ID. The datasource of this drop down list box is my employee table, which includes both Employee Name, Employee ID and also a TrueFalse field, which is checked when an employee leaves our company.

I would like to filter my drop down list box, so as to only display employees that are still with us, by use of the TrueFalse field.

As deleting former employees is out of the question, I see no other solution than the use of my suggested filter.

I believe that I've seen a question like this before, and like me, he used an Access DB, but now I can't find it.

Hi rasmus,

There are several ways that you can do what you want to do, here are some links that should help you get started:

http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=3181

http://blogs.msdn.com/infopath/archive/2004/09/10/227972.aspx

And since it sounds like your datasource is a flat structure, I would take a look at Greg's excellent tutorial on filtering a flat datasource:

http://www.infopathdev.com/howto/tutorials/default.aspx?i=075c4e8e56db4fa5bd63615b712c0d91

hope that helps!

Thank you so much Ted

Sorry for the late reply, had to attend a totally different matter for a few days.

I'm looking forward to looking it through.