https://www.infopathdev.com:443/forums/46.aspx For questions concerning issues in the integration of SharePoint and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/71000.aspxMon, 10 Oct 2011 19:43:06 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:71000csigler0https://www.infopathdev.com:443/forums/thread/71000.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=71000<p>Got it!!!!! &nbsp; If I had only known what to look for before. I knew it had something to do with the Rules and Filters! </p><p><a href="http://www.petestilgoe.com/2010/04/how-to-autopopulate-infopath-fields-using-sharepoint-list-data/">http://www.petestilgoe.com/2010/04/how-to-autopopulate-infopath-fields-using-sharepoint-list-data/</a></p>https://www.infopathdev.com:443/forums/thread/70998.aspxMon, 10 Oct 2011 19:10:57 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:70998csigler0https://www.infopathdev.com:443/forums/thread/70998.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=70998<p>Yes, I am trying to accomplish in InfoPath 2010. </p><p>I have 2 list... List A = Route, Mileage (calculated based on Route)&nbsp;and Zone(calculated based on Mileage).&nbsp; </p><p>List B - Route&nbsp;(Lookup from List A).</p><p>On my NewForm.aspx (in InfoPath 2010) for List B&nbsp;I&nbsp;have the Route dropdown list which is working.&nbsp; I then need to be able to do something like if ListB Route = ListA Route, display ListB Mileage......&nbsp; on the form in a non-editable table cell.</p>https://www.infopathdev.com:443/forums/thread/70994.aspxMon, 10 Oct 2011 19:02:35 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:70994ErnestoM0https://www.infopathdev.com:443/forums/thread/70994.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=70994<p>I think what you&#39;re looking for is cascading dropdowns, which is very possible in an InfoPath form, but it sounds like your question does not involve InfoPath. I don&#39;t know whether cascading dropdowns are available out of the box on SharePoint lists. <a href="http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/260f75a3-8a15-4cdc-9c1b-a7a9fb9985e9/">Some info here</a>, <a href="http://social.msdn.microsoft.com/Forums/en-US/sharepointcustomization/thread/e44b302b-ab23-4d09-9b7f-923508e2fd59/">here</a> and <a href="http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/8e01d81e-7a98-4c84-ac8b-ed5ea1f8b228/">here</a>. Good luck!<br /></p>https://www.infopathdev.com:443/forums/thread/70992.aspxMon, 10 Oct 2011 18:41:12 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:70992csigler0https://www.infopathdev.com:443/forums/thread/70992.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=70992If I have a List with two columns, Name and Phone Number. Then I created a new list where I have Names in a dropdown being pulled from the first List. I want to autopopulate Phone Number on my NewForm.aspx based upon my selection, I jsut can&#39;t figure out how.&nbsp;