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/96250.aspxMon, 03 Mar 2014 13:23:48 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:96250wilkies0106aw0https://www.infopathdev.com:443/forums/thread/96250.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=96250<p><span class="gmw_">&nbsp;Yes, you would just need to filter the data base on the Employee Name or ID. You could also use the <span class="gm_ gm_0a8213de-6952-33ba-e0db-a12424c17710 gm-spell">getuserprofile</span><span class="gmw_"> service or the <span class="gm_ gm_f12af50a-9b21-3946-6271-2265e7c6fada gm-spell">getmanager</span> option too.</span></span><br /></p>https://www.infopathdev.com:443/forums/thread/96249.aspxMon, 03 Mar 2014 12:35:32 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:96249Freeman90050https://www.infopathdev.com:443/forums/thread/96249.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=96249We would like to have the drop down list on our forms to be automatically filled for the user with his/her supervisor. Here is how it could work: We have an external (Oracle or SQL) database, where we have all the leaders and their current location on the company. We query the current user from his/her winlogon, and we have here his/her data (location) in the form, and we would like to be able to automatically choose the leader of the current user (matching there locations) - but if necessary he/she could change it from the dropdown list, in case they moved department. Is it possible to do in IP 2013? Thanks for your answers in advance, Gergő