InfoPath Dev

 Apparently Calculated value was the answer to everything in the form except the color coding which I still can't get that working correctly. But I do have a calculated value field that will say if they are banned or just received a warning, but I can't make the color coding change. Which ever rule is fist it just highlights the field ...

 I changed my yes/no check box to a dropdown with multiple values. So now in my conditions I have two name=name and Banned="Banned" but it still does not work. Do I need to write a formula for it to correctly pull the correct banned value from the record or when I select it from the drop down is it just searching in general.

 Update. I have the descriptions showing up now, and it only shows the data for the name in the field, but it shows a blank entry in the repeating table for everyone in the list. So any way to clean that up would be great.   If I set name=name  list1 to list 2 then set (list2)banned="True" it will highlight red. If I ...

I am trying to create a list system that we can record users but also look them up in a list to see if they are banned or have a warning flag. What I have is two list. 1. which is a list that we can record their name. 2. which is a list that has their name, description, and a banned yes or no checkbox. What I am trying to do is make a ...