Noob needs help with data validation against database data

E

ebferro

I've developed a form into which I'd like to enter some daily productivity
data. One of the fields in the form is Machine No. I'd like to allow my
users to enter a machine number and then validate the number against the data
that's stored in my machine database. Could someone post some code or point
me to some code that would allow me to do this? The machine number field on
the form is going to a table called production and the machine number field
for validation is in a table called machine. Both tables are in a SQL Server
database. Do I need to put the machine number field from the machine
database on the infopath form somewhere if I want to validate against it?
Thanks in advance.
Ernie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete all data after a symbol in a field 0
Copy previous record into form field 0
Call a stored procedure to validate a cell 1
Page numbering with Merged Document and IF statements 1
Validate Data Against An Excel Document 3
Using Access Database to build contracts with fields on pdf document 0
MS Outlook inbox to MS Accsess Database 0
Data Validation against secondary data connection 0

Top