InfoPath Dev

I built my Infopath form using a database connection.

One table has Dates(Oct06, Nov06, Dec06...)
Another table has Project status information. Each project must be statused monthly(which is where the dates come in)
Date is linked to Project info as 1 to many.

I need a drop down in my enter new project information form that only lists dates that have not been entered previously.

The drop down should only contain dates that do not have a record in the Project status table.

There must be a way to filter dates per project that have not been used before.

Please help

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

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

Hope this helps.

Thank you for these links but they do not pertian to my question.
However they will be great for future reference.

What I need is a drow down box of dates (Oct06, Nov06...)When one of the dates are chasen for a particular project, the date no longer shows up in the drow down box. This way the project manager can only choose a date that has not been selected before. This will prevent duplicate transmition of data.

Project manager #1 chooses one of his projects and in the drop down there are dates that he has not entered data for. He chooses a date and enters data and submits, the data transmits to the database backend. The next time he uses the drop down box the above date is no longer there.
Project manager #2 chooses one of his projects and he can see all of his dates that needs data in the dropdown box. and so on...

can anyone help with this??

Hello deb,
Have you tried this linkhttp://www.infopathdev.com/howto/tutorials/default.aspx?i=1fe635d7e2cd4c478b7a1eea929153ea