C
Chrisf
I am new to InfoPath 2007 and need to get the values from Oracle tables for
the cascading drop-down lists. I used this article as a reference:
http://blogs.msdn.com/infopath/archive/2006/10/12/cascading-dropdowns-in-browser-forms.aspx
I created a web method GetDiv() to get a list of divisions from an Oracle
table and a web method GetProg(string strDivID) to get the list of academic
programs from an Oracle table for the division selected and tested the web
methods as described in the article.
Added two drop-down list boxes by themselves on an InfoPath form with the
names SelectDiv and SelectProg.
Went to Tools/Data Connections and created 2 “Receive Data†data
connections. The 1st one is GetDiv with “Automatically retrieve data when the
form is opened†option. The 2nd one is GetProg specifiying “BT†as the sample
value for the strDivID parameter and unchecked the “Automatically retrieve
data when the form is opened†option.
Went to the SelectDiv list box properties to set the data source to GetDiv
and specified division_id for the Value and division_desc for the Display
name properties, and then went to the SelectProg list box properties to set
the data source to GetProg and specified program_id for the Value and
program_desc for the Display name properties.
Previewed the form and the 1st list box correctly lists the division
descriptions.
The next step according to the article is to create a rule on the 1st list
box which in my case is SelectDiv with 3 actions. This is where I am having
my problem. The 2nd action looks like this in the article : Set a field’s
value: strCustID = .
I’m not seeing my parameter which is strDivID listed when I click on the
button next to Field, only myFields and under that, SelectDiv and SelectProg.
Am I missing a step somewhere? Any help would be deeply appreciated.
the cascading drop-down lists. I used this article as a reference:
http://blogs.msdn.com/infopath/archive/2006/10/12/cascading-dropdowns-in-browser-forms.aspx
I created a web method GetDiv() to get a list of divisions from an Oracle
table and a web method GetProg(string strDivID) to get the list of academic
programs from an Oracle table for the division selected and tested the web
methods as described in the article.
Added two drop-down list boxes by themselves on an InfoPath form with the
names SelectDiv and SelectProg.
Went to Tools/Data Connections and created 2 “Receive Data†data
connections. The 1st one is GetDiv with “Automatically retrieve data when the
form is opened†option. The 2nd one is GetProg specifiying “BT†as the sample
value for the strDivID parameter and unchecked the “Automatically retrieve
data when the form is opened†option.
Went to the SelectDiv list box properties to set the data source to GetDiv
and specified division_id for the Value and division_desc for the Display
name properties, and then went to the SelectProg list box properties to set
the data source to GetProg and specified program_id for the Value and
program_desc for the Display name properties.
Previewed the form and the 1st list box correctly lists the division
descriptions.
The next step according to the article is to create a rule on the 1st list
box which in my case is SelectDiv with 3 actions. This is where I am having
my problem. The 2nd action looks like this in the article : Set a field’s
value: strCustID = .
I’m not seeing my parameter which is strDivID listed when I click on the
button next to Field, only myFields and under that, SelectDiv and SelectProg.
Am I missing a step somewhere? Any help would be deeply appreciated.