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/39487.aspxFri, 13 Mar 2009 05:02:24 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:39487Ian Dawson0https://www.infopathdev.com:443/forums/thread/39487.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=39487<p>Hi,</p> <p>I would like to have a primary table record field show a secondary database records key field. </p> <p>(Actually it is the primary table also hooked up as a secondary table, but only for viewing one table.<br />&nbsp;A table that when added to the primary data connection, blocks all data submits.)</p> <p>When I design the FORM and add the binding to the form, I am notified that I will only be returned the first record in the table.</p> <p>THAT MAKES SECONDARY DATABASE or File pretty useless??</p> <p>Surely there is a way to connect to the correct record in the secondary database???</p>