https://www.infopathdev.com:443/forums/46.aspx For questions concerning issues in the integration of SharePoint and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/105987.aspxTue, 29 Mar 2016 20:44:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105987ask.shruts20070https://www.infopathdev.com:443/forums/thread/105987.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=105987That worked. You are genius. Thank you so much.https://www.infopathdev.com:443/forums/thread/105909.aspxTue, 22 Mar 2016 14:44:37 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105909Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/105909.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=105909You should be able to do this with a filter on the drop down options - select the first list for your users, then in the filter, the first drop down would be the user name from the first list, then "is equal to", then in the third drop down, use a formula. In the formula editor, pick the user name from the second list, and click the Filter Data button - this filter would be Role (in the second list) is equal to whatever field or value determines the role you want.https://www.infopathdev.com:443/forums/thread/105832.aspxWed, 16 Mar 2016 18:34:42 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105832ask.shruts20070https://www.infopathdev.com:443/forums/thread/105832.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=105832I have two Lists in the Info path form. 1. All users 2. Users with With roles where user name is looked up from the List 1. Now in the Drop down I need to Display List of person who has set to role X in list 2 and only who are joined form List 1 to 2. I need to join list 1 and 2 as look up column shows id of users in the drop down other wise. So to get tile I have to join them Thanks,