Data Connections

Re: Question about Infopath and database connection

poolar — Mon, 04 Feb 2008 06:30:56 GMT

Thank you. It works :)

Re: Question about Infopath and database connection

Clay Fox — Tue, 29 Jan 2008 15:44:28 GMT

If this is a secondary data connection to a table with ID and Emails, they will all be loaded into your form when it is qureied and then you can use a filter to get the exact address. If you want dynamic queries you must use a web service.

So on your email address you would have a rule with a condition, field = epost in your secondary and if true will fire an action.

Question about Infopath and database connection

poolar — Tue, 29 Jan 2008 08:45:34 GMT

I have a connection to my access database in Infopath, ..

This is what I wan't to do:

When I type my mail adress in one textfield, I want the rule to chek if my adress exsists in the database. Could I change the SQL question to chek the field??

This is the question that the form does when I type in the field. I want it to chek the value in the field..
select [AnvId],[EPost] from [tblAnvändare] as [tblAnvändare]

If anyone knows what I meen?? Can I do this, or are there any other way to do it??