Hi,
I'm trying to do some validation on a data entry field but can't seem to get it to work!
I have a form which is connected to my main SQL data source.
Whithin this form is a Text field which is bound to a field called STCODE. When the form is compleated the value in the STCODE field is submitted to the SQL database.
I have also set up a second SQL data connection which is a list of around 30,000 valid STCODES.
The name of the secondary field is called CODE. I only use this field for comparison, not entering data.
What I would like to do is when a user types in an STCODE and moves to the next field, to check if what the user has entered in the STCODE field is already in the secondary data connection field of CODE.
If the STCODE appears in CODE the code is valid and the user can carry on with the rest of the form.
If STCODE does not appreas in CODE show an error message.
The steps I have followed are:
Clicked on STCODE text box properties.
Clicked Rules and added the condition "STCODE is not equal to CODE" to select the CODE field I used the "select a field of group.." and navigated to the secondary data source.
Added Action to show a dialog box with invalid code message.
I've found this thread but I'm still having no joy :(
http://www.infopathdev.com/forums/p/7968/29029.aspx#29029
Have I actually got to enter formula in the condition?
Not sure where I'm going wrong??!?
Any help would be much appreciated.