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/61396.aspxMon, 15 Nov 2010 01:46:33 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:61396Patrick Halstead0https://www.infopathdev.com:443/forums/thread/61396.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=61396<p>Hi AT,</p> <p>You don&#39;t need code to add a dropdown to your form that looks up data from a SharePoint list or library. Just add a data connection and specify SharePoint. You can also add a data connection that populates a dropdown from a database but Web Services are a best practice for querying databases since the default functionality doesn&#39;t allow for parameterized filtering of the data (but with browser-based forms, you may not care if it&#39;s server-to-server since there&#39;s no huge perf disadvantage to populating thousands of items).</p> <p>SharePoint does not provide out-of-box item-level permissions.&nbsp;To restrict read access you will have to either move the data to different lists/libraries, or if using a database, use a third-party tool such as Qdabra&#39;s DBXL which does support item level permissions on XML files. </p> <p>A partial workaround is to create a separate list that specifies access and keep the item-level access info in a column and just filter on that during form open. The user could still navigate to the list and see all the values, but they wouldn&#39;t see them from the InfoPath form and if they don&#39;t know the URL to the list you may be ok with this solution. </p> <p>Best of luck,</p> <p>&nbsp;</p>https://www.infopathdev.com:443/forums/thread/61362.aspxFri, 12 Nov 2010 13:29:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:61362jpat010https://www.infopathdev.com:443/forums/thread/61362.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=61362<p>Hey guys,</p><p> I&#39;m a newbie at sharepoint etc., so I hope you guyes are able to help me...</p><p>&nbsp;</p><p> I have a infopath 2007 form that I have published to sharepoint 2007. Since I need my user to save the infopath form where they currently are, I&#39;ve used the following code in tip #3 from: http://blogs.msdn.com/b/uksharepoint/archive/2009/02/03/top-tips-for-infopath-form-development-with-sharepoint-part-1.aspx</p><p> Since I applied that code, DataConnections dont work (the code in that link overwrites the dataconnection(s)). I need my form to look into my sharepoint server and add a dropdown box, so that I can choose data. I only need this done for 1 or 2 colums. The data has to have user security, meaning: if user A in sharepoint has access to view data 1 and data 2, he will be able to use the dropdownbox and apply either data 1 or data 2 to the form. If the user doesnt have access, they they will be invisible.Its important that the user doesnt not see what he doesnt have access to. </p><p>&nbsp;</p><p>Is this possible?</p><p> Looking for a fast responce and thanks in advance! :) </p><p> AT</p>