https://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/17250.aspxThu, 16 Mar 2006 10:47:26 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17250leonbns0https://www.infopathdev.com:443/forums/thread/17250.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=17250Yes, it is succeeded!<br /><br />I use a rule on the pulldown menu with some filtering.<br />The filter/action code is: @Address[@Name = field1]<br />(where field1 is my pulldown menu).<br /><br />https://www.infopathdev.com:443/forums/thread/17249.aspxThu, 16 Mar 2006 06:31:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17249Patrick Halstead0https://www.infopathdev.com:443/forums/thread/17249.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=17249Hi Leon,<br />This is filtering. Check out the HowTo articles. There should be a bunch describing how to do this.https://www.infopathdev.com:443/forums/thread/16793.aspxWed, 15 Mar 2006 19:17:31 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16793leonbns0https://www.infopathdev.com:443/forums/thread/16793.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16793Hi,<br /><br />I have a database with a table called "COMPANY" with some columns "Name", "Address", "City".<br /><br />Now I have create an Infopath form, with a lookup(pulldown) list.<br />The list is connecting to column "Name" (this is working!).<br /><br />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.<br />But I don't know how I must do this!<br /><br />Can anybody help me,<br />Thanks,<br />Leon