https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/38594.aspxWed, 18 Feb 2009 21:22:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:38594cf40hz0https://www.infopathdev.com:443/forums/thread/38594.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=38594Hello all, I am new to the forum. I am having troubles linking or connecting two data connections. I am connecting to a SQL server through UDC in which the information could be accessed through the net. I have 2 separate connections with specific queries. First connection is company which has columns for COMPANYID, Name. Second connection is contact which has columns for COMPANYID, Fullname . . . Both tables are linked in SQL by COMPANYID. I was able to create a drop down list displaying the Name for any given company. When I select a company name, I would like Infopath to display the contacts associated with that company and re-query when a different company is selected. I have tried filtering, but could only get it to work when I display the COMPANYID in the drop down list which is meaningless information. Any help would be greatly appreciated. My brain cells thank you all.