Set info path field based on entry in another field

[MJV57]

I have an info path form that has a combo box which selects an item number from an sql database and i would like to have a description field be updated based on the item number selection. The description is also in the sql database. Can anyone help me?

 

[SkipVought]

Hi,

Use a query with the selected item number as a criteria, to return data from the field of interest.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[MJV57]

Not sure where this is done within infopath.

 

[SkipVought]

How did you populate your combobox with the item numbers from an sql database?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[MJV57]

I bound it to data source icitem. And then selected value and display as @itemno. Now I need to set another field to the corresponding field in the data base named @desc

 

[SkipVought]

This link has information regarding, "use the form to query the database."

http://office.microsoft.com/training/training.aspx?AssetID=RC011879111033&pid=CR061832771033

Unfortunately, I know NOTHING about InfoPath.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]