InfoPath Dev

I have a drop-down list to select the department on a form. The departments also have ID numbers that are being stored as the value with the name of the department as the display. I had manually typed in the list but because I want to display it in other places, I made a SQL database to it. I got the connection working just fine for the list, but there were rules that are based on the value in this field - they are not working anymore. Any ideas???

Hello Jbabcock,
Rules do not change when you change data connection for the list, but they get changed when you change binding to a new field in XML. If you have changed binding then you need to set all the rules again.

Hope this helps!

So, you're now using the "Look up values in a data connection to a database, Web service, file, or sharepoint library or list" option?

Have you set the "Value" and "Display Name" fields below?
Just a thought