https://www.infopathdev.com:443/forums/141.aspxQdabra is committed to answering InfoPath questions. However, we do not support Microsoft Access. For non-Access questions, please use the other boards.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/63545.aspxTue, 25 Jan 2011 23:27:40 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:63545Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/63545.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=141&PostID=63545<p>I&#39;m afraid I&#39;m not super familiar with Access -- but can you create a view based off your query? You can select a view as a secondary data source in InfoPath. </p> <p>But can&#39;t you just relate the tables in your data connection? So, create a secondary data connection to Access, select your main table, then click the &#39;add table&#39; button in the data connection wizard and define the relationship between the tables....</p>https://www.infopathdev.com:443/forums/thread/63454.aspxMon, 24 Jan 2011 06:52:59 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:63454UdayaHerath0https://www.infopathdev.com:443/forums/thread/63454.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=141&PostID=63454<p>&nbsp;I am using info path 2003 and MS access 2003.</p><p>In my data base I have two tables which has 1..m (one to many) relation ship. I want to query results from many table when user enter the selection. I wrote a query in the access database. I want to add that query as a secondary data source to the info path . When user select the query value from Drop down I need fetch values related to the search criteria. How can I add that query as a secondary data source to the info path? Thanks<br /></p>