General

Re: check to see if an infopath text field is not equal to a list of fields from sql table

Hilary Stoupa — Sat, 14 Jan 2012 00:05:30 GMT

For the condition for the validation, select your secondary data source field first. When you select the field, at the bottom of that dialog, where it displays what you've selected, there is actually a very hard to notice drop down. You can change that to "Any occurrance of" the field you are selecting.

Re: check to see if an infopath text field is not equal to a list of fields from sql table

bsieloff — Fri, 13 Jan 2012 19:57:59 GMT

Very cool!

How did you get the repeating field to load all the "Name" fields?

Thanks,

-Bob

Re: check to see if an infopath text field is not equal to a list of fields from sql table

Hilary Stoupa — Thu, 12 Jan 2012 01:13:37 GMT

I've attached a sample with a data validation rule that does what I think you want. When selecting the field from your SQL connection for the first part of the condition, you can use the drop down in the field selector to pick "Any occurance of" the field being equal to your main data source field. Save the sample locally, right click and select design to open in design mode and preview.

check to see if an infopath text field is not equal to a list of fields from sql table

bsieloff — Wed, 11 Jan 2012 20:12:04 GMT

Hello,

I have a data connection to a sql table. The table contains a bunch of entried (for example names). I want a user to type into a text box in infopath a new name but have infopath make sure that the name has not been used in the past by checking against the sql entries.

I created a drop down list box connected to the sql table and I can see all the entries, but I'm not sure how to compare the newly entered text (text box) to the entries in name field from the sql table.

any ideas?

Thanks,

-Bob