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/2020.aspxWed, 15 Mar 2006 22:01:48 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:2020Matt Faus0https://www.infopathdev.com:443/forums/thread/2020.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=2020Hi shohman and welcome to the forum!<br /><br />You should be able to do this with a default value formula and a data filter on the text box. See if these steps help:<br /><br />1. Double-click the text box<br />2. Click the function button beside the default value field<br />3. Click Insert Field or Group<br />4. Expand your secondary data source to the customer name<br />5. Click the Data Filter button on the bottom left of the Select a Field or Group dialog box<br />6. Choose the ClientCode node in the first drop-down, equals in the second drop-down, and Select a Field or Group from the third drop-down<br />7. In the dialog box that pops up, go back to your Main DOM and choose the node that the ClientCode drop-down is bound to.<br />8. Click OK about 8 times.<br /><br />Hope this helps!https://www.infopathdev.com:443/forums/thread/1196.aspxWed, 15 Mar 2006 20:40:38 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:1196shohman0https://www.infopathdev.com:443/forums/thread/1196.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=1196I have a secondary data connection to a Windows SharePoint Site List. I would like to have a drop box list all of the client codes in one column of the list and upon a user selecting a client code, the name appears (which is in another column in the list) in a text box to the right of the drop list. I am sure this can be done without coding buttons and stuff. I just want the user to be able to make a selection and the corresponding name to appear.<br /><br />So far, i have been able to make the first line of the name column appear, but not the proper name (when I different code is selected).<br /><br />Thank you for any assistance you can offer this InfoPath Rookie.<br />