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 form to fill in list 1. But once the name is typed to check list 2 to see if they show up in the banned/warning list. If they don't hit submit and they are added to list 1. banned users we would not allow and users with warning we would watch.
If they show up in the list I would like to change the background of their name to red if banned and yellow if on the list but the banned checkbox is not checked.
Also if they show up in the list show the description field on the page.
I have a form now that will highlight the name red if they show up in the 2nd list. But I can't seem to get it to lookup the banned yes or no box. I was able to get the form to display data from the description but it either shows the first or last in the second list.
Any help would be greatly appreciated.