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/27668.aspxThu, 03 Apr 2008 15:11:15 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:27668Clay Fox0https://www.infopathdev.com:443/forums/thread/27668.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=27668<p>I would guess it has to do with your table relationships.</p> <p>You may need to create a seperate data connection for just products.</p> <p>Do you have a lot of records?</p> <p>I can show you how to also query your secondary data connections.</p>https://www.infopathdev.com:443/forums/thread/27658.aspxThu, 03 Apr 2008 12:42:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:27658qui840https://www.infopathdev.com:443/forums/thread/27658.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=27658<p>hi,</p> <p>i&#39;ve got a new problem :)...</p> <p>for example: i created a&nbsp;access db, with 2 tables (1 table for the suppliers and 1 for the products [1:n]), and created a form in infopath and got<br />a connection with the access db. i have the queryFields and the dataFields on my form. it works, when i search for<br />suppliers. it shows me in the dataFields the entries. BUT when i search for a specific product, it shows me ALL<br />supplier-entrys and somewhere in the dataField-list&nbsp;the product and his supplier what i was searching for .....</p> <p>how can i realize it, that he just show me the product-entry with his supplier.... ?</p> <p>i&#39;ve did it like this: <a href="http://office.microsoft.com/en-us/infopath/HA011199501033.aspx">http://office.microsoft.com/en-us/infopath/HA011199501033.aspx</a></p>