Question about querying data from sql database to form

[g21cincy]

I have already created a form that submits data to a SQL database. I was
wondering if anyone could either tell me how or show me a site that would
help me in querying a database to fill the form. For example, if someone
entered an account number in that field and clicked the query account number
button. Would it be possible to populate the form based off of that account
number?

Thanks!

 

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

You basically have to modify the SQL statement for the connection to the
database and add a WHERE-clause to it. The following article uses InfoPath
2003 and an Access database, but the concepts are the same for an InfoPath
2007 form bound to a SQL Server database:
http://www.bizsupportonline.net/infopath2003/query-access-database-list-numbers.htm .