https://www.infopathdev.com:443/forums/142.aspxAre you exploring new features coming up in 2010? Share information and ask questions here!enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/97685.aspxWed, 28 May 2014 17:52:18 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:97685jazaddict0https://www.infopathdev.com:443/forums/thread/97685.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&PostID=97685<p>So here&#39;s what I did:&lt;b&gt;</p> <p>&nbsp;Made an additional secondary connection to the list which infopath made the initial 2ndary&nbsp;which included the fields I wanted.&lt;b&gt;</p> <p>Made rules that Set Field Values by filtering from the dropdown of the initial secondary&nbsp;to the proper record in the New 2ndary to source data .&lt;b&gt;</p> <p>Submitted the to the Main.&nbsp; </p> <p>&nbsp;</p>https://www.infopathdev.com:443/forums/thread/97666.aspxTue, 27 May 2014 18:20:38 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:97666jazaddict0https://www.infopathdev.com:443/forums/thread/97666.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&PostID=97666My Person list has a lookup to the various companies for whom they could work; each person will only have one company. The Company list has several fields corresponding to that company: address, phone, manager, etc. In Sharepoint I created a lookup field on the Person list to the Companies list by Title (seems safe that there won&#39;t be duplicate titles), and then &quot;included&quot; the Address, Phone, and Manager name of the company to make a total of 4 fields in the Person list that &quot;come from &quot; the company list. Works great, I select a company, all 3 other fields populate. THEN I created my InfoPath Web Form based on the Person list, and it created the a secondary source to &quot;Companies&quot;, and the drop down shows me Company names (title), but I can&#39;t &quot;see&quot; the rest of those fields....they aren&#39;t in the &quot;Main&quot; connection, and the only 2 fields in the Secondary Companies connection are ID and Title w/ no editting available. It seems to me that the rest of those Company fields should be &quot;available&quot; for me see from the Infopath form.....somewhere...???? My effort to solve this myself (which didn&#39;t quite work): I created a NEW secondary to the Companies list during which I could select those additional fields........ I can see them in the new Company secondary source datafields, but draggin them onto the form get added as a &quot;repeating table&quot; which I don&#39;t want/need. What I&#39;m tryin to do is : When the Infopath user selects a Person to edit, the form fills with that record&#39;s field data, they should be able to select a company &amp; have all that company&#39;s data fill....and/or, when they select a Person to view, the previously selected company with all the info is read-only visible. Seems easy, but I&#39;m a little wrapped around the axle here.....can somebody explain where I&#39;m going wrong? How to get the selected company &quot;title&quot; field in a dropdown to populate the Address, Phone, Manager fields on the form?