Data Connections

Re: Populate a Dropdown on condition

saudak — Sat, 30 Jun 2007 11:01:16 GMT

Thanx clay

I came up with a the way ... the problem with me is, I start writing code before starting to see the control formatting in InfoPath itself.

I made it into one datasource with onother field on which I added a filter and it worked.

Re: Populate a Dropdown on condition

Clay Fox — Fri, 29 Jun 2007 15:07:04 GMT

The simple, basic way to do this is just to have both drop downs, B_1 and B_2 on the view but Hide them both until A is chosen and then do not show the one you don't need. So depending on A's value show the corresponding B dropdown and keep the other hidden and vice versa. I am not sure having a dynamic drop down from two seperate tables is possible but this is a lot simpler and the user would never know the difference.

Populate a Dropdown on condition

saudak — Thu, 28 Jun 2007 16:09:37 GMT

Hi,

I have 3 datasources A , B_1 and B_2, I have 2 dropdown lists drpA and drpB, I populate drpA with datasource A, Based on the value of drpA, I need to load drpB with B_1 or B_2

Like:

in drpA if the selected value is 1 I have to load B_1 in drpB else

if the selected value is 2 I have to load B_2 in drpB .

Any Ideas??? Please help

Update:::

I wrote a little code that gets the value of drpA and select the datasource , but I cannot populate the values I get from the datasource, into the drpB

I was thinking on the lines ;;;

For i = 0 To objdsB_1.length - 1

XDocument.DOM.selectSingleNode("/my:myFields/my:drpB").Add = objdsB_1(i).selectSingleNode("@data").text ' This doesnt work!