Question about Infopath and database connection - InfoPath Dev
in

InfoPath Dev

Question about Infopath and database connection

Last post 02-03-2008 10:30 PM by poolar. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 01-29-2008 12:45 AM

    • poolar
    • Not Ranked
    • Joined on 01-29-2008
    • Posts 3

    Question about Infopath and database connection

    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??

  • 01-29-2008 07:44 AM In reply to

    Re: Question about Infopath and database connection

    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.

  • 02-03-2008 10:30 PM In reply to

    • poolar
    • Not Ranked
    • Joined on 01-29-2008
    • Posts 3

    Re: Question about Infopath and database connection

    Thank you. It works :)
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.