Thanks for any help you can offer folks. I have a very simple form. The only field is ID_Name. I want the user to choose a unique ID name, and I want to be able to control the responses.
if(input.ID_name == "Jenny")
{
alert ("Sorry, this ID name is taken. Try again.");
cancel submit;
}
This On Validate script would work perfectly if they chose the name Jenny. Basically, what I want is to say (instead of Jenny) - any name that is listed in the field called All_ID_names, which is in the View called Client_List.
The All_ID_Names field is set to not accept duplicate entries. However I don't suppose it need to be, if I can get the script above to work.