Infopath SQL Behavior

[vgame64]

Hi all.

I have an InfoPath form I am making that collects data from a SQL
table.

What I want it to do, is when the account name drop down selection is
made, to automatically populate the text box (ACCOUNT_NUMBER) next to
it with the account number information corresponding to the account
name from the SQL table.

basically....SELECT CHAIN_NUMBER FROM DATABASENAME WHERE CHAIN_NAME =
infopath accountname field

Thanks for any help

 

[Don Reamey \(MSFT\)]

You can create rule to populate the textbox. However without knowing more
about your environment I can't give any more specific advice.

--
Don Reamey
Software Development Engineer
InfoPath Forms Server
Microsoft Corporation
http://blogs.officezealot.com/dreamey

 

[Swathi (GGK Tech)]

Hi,
In the drop down on after change event, get the value of the drop down. Then
Execute the query with the drop down value and set that value to the text box.