Struggling with simple things

[IT PHYTOSAN]

I have a form based on a data connection to an SQL data base. There is a
repeating table linked to Parts.dbo. The first four digits of a part number
is the parts lot number. I would like to achieve that when a user scans a
part number that there is a validation error if the lot number does not exist
in the data base. for that purpose I have created a secondary data connection
to Lot.dbo.

I have been trying for over a week now to get the validation to work.

Any hints?

Thanks

IT PHYTOSAN

 

[S.Y.M. Wong-A-Ton]

Add data validation to the field that needs to be validated as follows:

1. Double-click on the field to open its Properties dialog box.
2. Click on the "Data Validation" button.
3. Click on the "Add..." button in the "Data Validation" dialog box.
4. In the "Data Validation (<field_name>)" dialog box:
- Select the field to be validated from the first drop-down list box.
- Select "is equal to" from the second drop-down list box.
- Select the field in the secondary data source to compare the field to be
validated to from the third drop-down list box.
- Select "The expression" from the first drop-down list box.
- Enclose the expression that is already shown in the text box behind the
first drop-down list box by "not(...)". So you would end up with an
expression like:

not(. = xdXDocument:GetDOM(...)/...)

 

[IT PHYTOSAN]

Thank you very much for a very detailed answer. I found that I had to select
"Any occurances of Lot" does not equal "Lot ID of current part" I will check
your proposal and let you know of any observations.

Thanks again

IT PHYTOSAN

 

[S.Y.M. Wong-A-Ton]

The instructions I gave are for InfoPath 2003. It sounds like you're using
InfoPath 2007?

 

[IT PHYTOSAN]

That is correct. Hughe improvements, by the way.

IT PHYTOSAN