Validate against secondary data source

[David Kassa]

Hi,

I still can't seem to figure out how to use a secondary dat source to
validate against a textbox/Main data source field. I can limit a users
options to a secondary data source with a drop down listbox, but using one
forces the operator to use a mouse or arrow key - interrupting flow. Instead,
I'd like to have free text, but check the value after the update.

As I said previously, I thought it would be as easy as using the validation
wizard and saying "Field not equal to @secondaryDatasource", but this always
evaluates as true.

I've tried removing "white space" with no success. I now think it makes
more sense to have something like "secondaryDatasource does not contain
Field", but this doesn't work either. COuld it be because only the 1st record
in secondaryDatasource is being pulled? (something I'll now check)

Do I have to (or how do I) initialize the secondary data source besides the
initial refresh on form open? Does the secondary data source have to be bound
somehow, so that each element can be compared?

I thought that this would be very intuitive, but obviously this is no longer
the case.

ANY help would be extremely appreciated!


Thanks in advance,

David Kassa

 

[David Kassa]

So it is the case that if I say "@secondaryDatasource does not contain Field"
(or even vise versa) that the 1st record in my 2nd datasource is valid, but
the rest are not.

PROGRESS!!!

However, I still can't repeat/check every instance of my datasource. When I
try to add a repeating section, it will not allow it. (in another repeating
section from Main datasource). Is there any other way of doing this?