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/85975.aspxFri, 11 Jan 2013 17:11:31 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:85975varam4u0https://www.infopathdev.com:443/forums/thread/85975.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=85975Got it how to do. Simply we need to create data connection and apply filters when dropdown value changes then assign the required value of filtered record. Thank u.<br />https://www.infopathdev.com:443/forums/thread/85972.aspxFri, 11 Jan 2013 16:49:40 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:85972varam4u0https://www.infopathdev.com:443/forums/thread/85972.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=85972<p>Hi,</p><p>Scenario: There are three sharepoint custom lists like below.</p><p>List 1 (Groups) contains column &#39;Group&#39;<br /></p><p>List 2 (Categories) contains column &#39;Category&#39;</p><p>List 3 (Codes) contains columns&nbsp; : Group (lookup), Category (lookup), Code (single line of text)</p><p>I need to show two dropdown lists which shows Groups, Categories. Based on the selection of group &amp; category i need to show &#39;Code&#39; in textbox.</p><p>Could you please let us know how to achieve this task</p><p>Regards,</p><p>KV. <br /></p><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;<br /></p>