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/21263.aspxTue, 26 Jun 2007 16:01:38 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:21263funniegrrl0https://www.infopathdev.com:443/forums/thread/21263.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=21263<p>woo hoo!</p><p>I had to fumble around a bit, but I was able to figure it out.&nbsp; Thanks so much!</p>https://www.infopathdev.com:443/forums/thread/21233.aspxTue, 26 Jun 2007 02:51:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:21233Clay Fox0https://www.infopathdev.com:443/forums/thread/21233.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=21233<p>You would have to reference your secondary data connection that feeds the drop down, not the dropdown directly, and use a filter to get the data you wanted.</p><p>item_name where item_id = dropdown field.</p><p>&nbsp;</p>https://www.infopathdev.com:443/forums/thread/21227.aspxMon, 25 Jun 2007 19:36:41 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:21227funniegrrl0https://www.infopathdev.com:443/forums/thread/21227.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=21227<p>Hi all --</p><p>I&#39;m a non-programmer, so the answer to what I think is a simple problem is eluding me.</p><p>I have a form that pulls some information from a database via a web service, then sends information back.&nbsp; There are two fields involved in this issue, item_name and item_ID.&nbsp; Naturally the ID is needed when sending info back so that the new data populates the correct record.&nbsp; The form currently has a drop-down field where the value is item_ID, but the display is item_name.&nbsp; The user selects the appropriate item using the drop-down, but of course the value is the ID number.</p><p>In terms of using the form, sending the data, etc. this works fine.&nbsp; The problem is that I want the main submit (a SharePoint form library) to automatically name the completed form based (in part) on the item name.&nbsp; I was able to do this when the display &amp; value where the same (pointing to a hand-typed list).&nbsp; Now that the value is the ID number, however, the file is named with the ID.&nbsp; I can&#39;t figure out how to tell it to either use the display data, not the value data, OR figure out a way to tell it to look at the data source and figure out which ID is tied to which name, and use the name as the file name.&nbsp; I&#39;m sure that if I had a better grasp of XML / XPath, the answer would probably be fairly obvious.&nbsp; But ... as it is, I&#39;m stuck!&nbsp; Thanks in advance for any assistance offered.</p>