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 same 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!

 

[Shiva]

Hello,

Check out these links,

http://office.microsoft.com/en-us/infopath/HP101070601033.aspx
http://www.bizsupportonline.net/inf...form-sql-display-in-new-instance-infopath.htm

 

[g21cincy]

I don't think those links have quite what I'm looking for. I'm basing the
form I'm doing off an old pdf form. On the pdf form you can click a button
and a javascript window will come up asking for an account number. When OK is
clicked the form will populate based on the account number looked up. Thats
what I'm trying to figure out with the form I'm doing.

 

[g21cincy]

I just figured out how to do it. I just made a new view that I can type in
the account number and it will query that field and populate that row into
the default view. Pretty cool!