https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/66378.aspxSun, 08 May 2011 20:08:28 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:66378Patrick Halstead0https://www.infopathdev.com:443/forums/thread/66378.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=66378<p>Hi SandeepReddy,</p> <p>How do you know which departments the manager has access to? Is it in Active Directory? If so, I recommend using our Active Directory Web Service which will allow complex queries of Active Directory data and enumeration of all users in a group, etc. You just can&#39;t use the UserProfile service in SharePoint to do the kind of complex queries it seems you will need.</p> <p>However, you still need to keep a list of who has access to what and control that somehow. You also haven&#39;t explained what you are going to do when they edit the data. Is this read-only or are they also submitting updates? Need much more detail here bro.</p>https://www.infopathdev.com:443/forums/thread/66365.aspxFri, 06 May 2011 23:24:18 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:66365sandeepreddy0https://www.infopathdev.com:443/forums/thread/66365.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=66365<p>Hi,</p> <p>&nbsp;I am working on sharepoint 2010 and infopath 2010.I need to design a infopath form which will be used by the managers.when the manager opens the form he needs to get all the department list in a drop down to which he has access and when he selects particular&nbsp;department in drop down all the users in that department should be retrieved and should bind to another dropdown.The user profile data is in the user profiles which are being synchronized from the active directory.Please let me know a better way to do this.</p>