InfoPath Dev

Hi, I am looking for help in the best way of autopopulating a form.  Here is the issue.  My form will receive data from a SQL database, a user will type in a unique identifier, once typed in I want to autopopulate the form with bio information which is stored on the SQL database.  Once I have an idea where to start I can start ...

Hi Patrick, Thanks for your quick response.  I am not sure what you are asking so I will explain my scenerio.  I want to create a form that a user types in a unique identifier which then pulls data from a SQL database (which our application uses to store information for our office)  The InfoPath form will also contain fields that ...

Well here goes for my first post.  I am wanting to connect an InfoPath form to a SQL database.  In connecting to the SQL database I am asked to enter username and password when I preview my form.  What is the best way to connect to a SQL database without the validation of username and password.  I am wanting to retrieve data ...