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/38193.aspxSat, 07 Feb 2009 10:16:59 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:38193Ian Dawson0https://www.infopathdev.com:443/forums/thread/38193.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=38193<p>A default seems to be that if a key field is blank, and the Query button selected. Then all records are displayed. If a value is&nbsp;entered for a key field, only that record is displayed.</p> <p>The Problem is :-&nbsp; If I have 2 key fields, each one a field from a separate table. I enter a value for the second field.<br />All records are displayed for the table represented by the first key field.&nbsp;</p> <p>I think I am going to have to DUPLICATE the 2nd key field in the same table as the first key field.!!&nbsp; <strong>True??</strong></p> <p>I have 7 ACCESS tables all linked by a key field, the first one above.&nbsp; the second key&nbsp;mentioned above is not .</p> <p>What can I do to only show records for the 2nd key??</p>