InfoPath Dev

Hi,

I have created two data connections for two SharePoint Lists using InfoPath 2003. I assigned each data connection to a List Box and I would like to update the value of one based on another. The first list has the columns Code and Name. The second has the columns Code and Title.
The first List Box was set up to receive the group with Code and Name as Entries and Name as Value and Display Name.
The second list box was set up to receive the group with Code and Title as Entries and Title as Value and Display Name. This Entry was set up to filter using List1 Code = List2 Code.
Doing this, only the first List Box received data.
What I should do to update these controls correctly?

Thanks,

Bruno

well you will have to use filters to update these correctly.

suppose you have

field1 contains data from connection 1(code, name)

field2 contains data from connection 2(code, title)

you will have to write rules on both these fields to update the other field

1) on field1

field2 = connection2.title where connection2.code = (select connection1.code where connection1.name = field1.value)

2) on field2

field1 = connection1.title where connection1.code = (select connection2.code where connection2.name = field2.value)

NOTE: this is only concept you will have to translate it into actual syntax

I was not finding a way to use the where with the rules, but now it worked.

Thanks