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/27895.aspxFri, 11 Apr 2008 17:56:57 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:27895Greg Collins0https://www.infopathdev.com:443/forums/thread/27895.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=27895<p>Hi, please only post a question once. If you need to provide more information, please add it on to your original question. Thanks.</p> <p>I&#39;m responding to your earlier post here: <a href="http://www.infopathdev.com/forums/p/7581/27729.aspx">http://www.infopathdev.com/forums/p/7581/27729.aspx</a></p> <p>&nbsp;</p>https://www.infopathdev.com:443/forums/thread/27819.aspxThu, 10 Apr 2008 00:46:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:27819Alchemist610https://www.infopathdev.com:443/forums/thread/27819.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=27819<p>I have created a database in access with some lookup fields that has Primary Keys.</p> <p>I can see the records perfectly in the Access Table, but when I run the Query in Infopath 2003,</p> <p>It returns the Primary keys instead of the assigned Fields with the data.</p> <p>Is it possible to have the Data displayed in the Infopath form without restructuring the Database?</p> <p>Can I make a Query of some sort that will extract the required information from the Database and </p> <p>I can use this Query as the focal point of the infopath form?</p> <p>Thanks.</p>