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/29746.aspxWed, 25 Jun 2008 14:22:02 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:29746chandrakanth0https://www.infopathdev.com:443/forums/thread/29746.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=29746<p>&nbsp;</p> <p>hi, </p> <p>I think this link will help you.</p> <p><a href="http://www.infopathdev.com/forums/p/1912/23829.aspx#23829">http://www.infopathdev.com/forums/p/1912/23829.aspx#23829</a>&nbsp;</p> <p>&nbsp;</p>https://www.infopathdev.com:443/forums/thread/29694.aspxTue, 24 Jun 2008 15:29:37 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:29694CRichardson0https://www.infopathdev.com:443/forums/thread/29694.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=29694<p>I&#39;m sure this is has been asked before but I can&#39;t find it.&nbsp;&nbsp; I have a Foreign Key column in&nbsp;table A&nbsp;that is just an &#39;id&#39; integer value, referencing a lookup table B, which contains the Primary Key and a text string description.&nbsp;&nbsp; Creating a &#39;New Record&#39; form in InfoPath, I want to create a dropdown list box that displays the string description fromthe lookup (Table B)&nbsp;but,when an item is selected from the dropdown list, the integer id is written to the FK column in Table A.&nbsp;&nbsp; It&#39;s a standard kind of thing to do but can&#39;t quite see how to do it in InoPath?</p> <p>&nbsp;Thanks,</p> <p>Clive</p>