InfoPath Dev

Hi,

I have a database with a table called "COMPANY" with some columns "Name", "Address", "City".

Now I have create an Infopath form, with a lookup(pulldown) list.
The list is connecting to column "Name" (this is working!).

Now I want, when I select a Name in my lookup list, then two other fields must be auto filled with the value's (Address and City) belonging to the company's Name.
But I don't know how I must do this!

Can anybody help me,
Thanks,
Leon

Hi Leon,
This is filtering. Check out the HowTo articles. There should be a bunch describing how to do this.

Yes, it is succeeded!

I use a rule on the pulldown menu with some filtering.
The filter/action code is: @Address[@Name = field1]
(where field1 is my pulldown menu).